Results 1 to 3 of 3
  1. #1
    Peborgh is offline Novice
    Windows XP Access 2002
    Join Date
    Jun 2015
    Posts
    1

    Displaying all fields in a combo box after selection

    I have a combo box in a a form. When I use it, it displays all the fields required (derived from its data source) so that the user can make a selection.


    It does put the required field in the field that is the recipient of this combo box.
    BUT it then only displays the first field only in the combo box, not all the ones it displayed when the user was making a choice.
    I am sure the solution is simple...

    Thanks,

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,610
    If you have the room to spare on your form I think the simple solution would be to create a new text box to display the concatenated values of the columns in the combo box.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Here is a thread that links to a video tutorial series.
    https://www.accessforums.net/tutoria...ers-52741.html

    The third video describes how to accomplish what Bob is describing in post #2
    (3) Display Combo Box Control Columns in Unbound Text Box Controls

    The files on the host site are compressed folders using the Microsoft Windows Utility. You may experience issues using WinZip to "unzip" the folder. The folder needs to be Un-Compressed.

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

Similar Threads

  1. Replies: 2
    Last Post: 05-08-2014, 01:51 PM
  2. Replies: 4
    Last Post: 08-18-2013, 07:40 PM
  3. Replies: 25
    Last Post: 01-25-2013, 10:26 AM
  4. Replies: 2
    Last Post: 12-07-2010, 12:32 PM
  5. Replies: 1
    Last Post: 09-27-2010, 06:58 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