Results 1 to 4 of 4
  1. #1
    msmithtlh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    151

    Subform - select a code and display its description in an unbound control

    I don't know if my problem is syntax or what.



    In a subform, I have a combo box, which shows a code and its description. When the user selects the code, I want the description to show in the next field on the form, which is unbound (I don't want to store the description, as it is long, just show it).

    I also have a simple query that will find the correct record, based on the code selected in the form, and return the description.

    I've tried several ways, unsuccessfully, to get that description to show up in the unbound control.

    I'm sure this can be done, but I'm stumped at the moment. Thanks in advance.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    Does this help?

    BaldyWeb - Autofill
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    msmithtlh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    151
    Yes!!!!!!! Thank you!!!!!!

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    Happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 12-21-2012, 01:57 PM
  2. i want to show description when i write the code
    By Mina Garas in forum Access
    Replies: 3
    Last Post: 02-23-2012, 11:00 AM
  3. Replies: 1
    Last Post: 07-11-2011, 04:35 AM
  4. Replies: 6
    Last Post: 06-13-2011, 12:14 PM
  5. Report control of a field display/no display
    By systems013 in forum Reports
    Replies: 5
    Last Post: 02-01-2010, 09:44 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums