Displaying all fields in a combo box after selection

[Peborgh]

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,

[Bob Fitz]

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.

[ItsMe]

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.