View Full Version : lookup display


dhoffman
06-19-2001, 07:48 AM
I have a form where one of the textboxes should display a name. This textbox's data source is a field which, rather than a name, provides a unique ID# identifying that name in another table. It seems that if I want the textbox to look up the name I must make it into a combo box, but I want it to stay a textbox. This data will not be edited by the user. What can I do?

AlanS
06-19-2001, 08:24 AM
There are several ways to do this. Probably the easiest would be to base the form on a query which includes the other table containing the name field, and then just set the text box's data source to that field.