Hi,
I need some help. I am sure this isn't too difficullt but I am kind of a beginner.



The source for my form is a table whose fields are numeric and perform lookups into other tables.

Now when I place a text box on my form whose control source is one of these feilds, I only see the number that is in the field of the table. I would like to see the "text" that is being looked up, not the ID number that is in the table.

This is a search form that will display the results from a search so I would like to have text boxes on it.

How to I do this?