Display data without combobox to get value ACCESS 2010

Sandra Smith
Sandra Smith used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
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
Sandra SmithRetired

Author

Commented:
That did it, thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial