Data from combo query not displayed

Folks,
I'm using Access 2010. My form has a field based upon bound combo box via query. When I execute the query I see the data I'm expecting. When I execute the combo box from the form the combo box shows the fields but only displays the first field from the query in the combo box, whereas I need to see all fields once I've selected the item from the combo box.
Frank FreeseAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PatHartmanCommented:
That is the way combo boxes work.  When in list view, you see whatever columns are contained in the RowSource and have a column width > 0 but when "closed", they show only the first visible column.

The simplest solution, is to add the lookup table to the RecordSource query for your form.  Use a LEFT JOIN to allow for a record to be shown even when nothing has been selected in the combo.  Select the columns you want to add to your form.  For all these "lookup" columns, set the Locked property to Yes to prevent accidental updating.  Now, when the user selects an item in the combo, the "lookup" fields on the form will automatically populate.  No code is needed.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
John TsioumprisSoftware & Systems EngineerCommented:
Go to design mode and change the column count in the format tab to the number of columns you want.
You can adjust the Width for each column from "column widths"
0
PatHartmanCommented:
tsgiannis,
Please reread the OP's problem.  He is already selecting multiple columns and can see them when searching the combo.  The column widths only controls the columns that are shown when the list is "open".  When the list is "closed" it shows only the first visible column.
0
Frank FreeseAuthor Commented:
thanks - I'll be back. This is NOT a difficult form I've just very rusty with Access
0
John TsioumprisSoftware & Systems EngineerCommented:
I missed that part ...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.