Display data without combobox to get value ACCESS 2010

I have a form that records new data and uses about 10 combobox boxes to let the user select a value.  There is the first hidden column that contains the ID and then they see the text string for that value.  However, I am creating a detail form that they cannot change, but when they select a client on the main form, the details for that client show up.  However, I need to have comboboxes for each field so they see the text string, not the ID.  Is there a way to simply have these at text fields and show the string rather than having the combobx drop-down which takes up space and is not needed as they cannot change this data.
Sandra SmithRetiredAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

Rey Obrero (Capricorn1)Commented:
you have to change the record source of the detail form to a query, joining the main table and lookups tables. In the query, select the text part of the lookup values and use that as the control source of the textboxes

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
Sandra SmithRetiredAuthor Commented:
That did it, thanks.
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.