Combo box selection is a number in the table/query

[jmuirman1]

I created a combo box to get values from another table. it works.



However, in the table/query i see only a number but want to search the field via text.

TYPE

Business App

Personal App

Software

Hardware

how do i show the text in the table/query so that i can search text rather than a number.

thanks,

John

[Bob Fitz]

how do i show the text in the table/query so that i can search text rather than a number.

You don't. Tables are for storing and relating data. To view the data the way that you want to see it, create a query and use that as the data source of a form or a report. The query will join the two tables and the the text value can be show in a column (field) of the query.

[June7]

Do search in a form, not table or query. Review http://allenbrowne.com/ser-62.html.

User sees text but your code could use number ID for search parameter. Controls used to enter search criteria should be UNBOUND.