Showing all of those fields when the combo box is OPEN is easy to do. Showing them when it's CLOSED (after something has been selected) is a little tricky. You need to join all of those fields together in a query first, then use that query field in your combo box. It's basic string concatenation that I cover in Access 104, lesson 3. In this lesson, for example, I merge FirstName and LastName into one visible field.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 3.