Displaying Lookup Value in Textbox

[robrich22]

I have a continuous form bound to an EVENTS table. In the events table there is a column BUILDING_ID. BUILDING_ID is currently setup as a lookup value in the EVENTS table. Anyways, I have the BUILDING_ID textbox on my continous form but I want it to display the full name of the building from the BUILDINGS table, based upon that BUILDING_ID.. But I don't want to do it with a combobox. I just want a regular textbox.



I hope this makes sense. Thanks in advance for your help.

Thanks

[JoeKra]

You can add a hidden combo box and set the text box control source to the column you want to see

[ssanfu]

If you are using Lookup FIELDS (in a table), this is a bad idea.
See: The Evils of Lookup Fields in Tables http://access.mvps.org/access/lookupfields.htm

You do not gain anything because in a lookup field (essentially a combo box):
- in a table, the actual value in the field is "hidden"
- you have to set up the same "combo box" on a form.

Back to your question, instead of using a table for the form record source, use a query. Virtually all of my forms use queries for the record source.

Join the EVENTS table with the BUILDING table on BUILDING_ID. Then add the full name of the building to the query. Set he text box control source to the Building Name.

[robrich22]

Thanks everyone for the replies. I am actually maintaining a legacy database and its painful because the prior DBA used lookup fields on everything. I decided to just start over and rebuild the tables.

Thank you for all the responses.