Need Textbox to display result of a lookup

[mkasson]

I've got a form for showing/editing my database records. One of the fields is City. I have a table which has two fields - the long version of the city name and the short version (LongCity and ShortCity). The City field on my form correlates to the LongCity version.

I'd like to add a textbox on the form that also shows the short version.

What's the best way to get it and put it on the page?

I don't want to change the control source for the main form because it seems to then not let me edit the recordset.

I don't know what I would set the control source for the txtShortCity textbox to, if that's the best route.

I'd rather not use code behind the form (e.g. to set the textbox based on a seek).

Thanks much.

- MSK

 

[mkasson]

Thanks for reading this, but I found Dlookup and set the textboxes control to a Dlookup function.


- MSK