Display Text

[accessuser1308]

I currently have a form that contains a list box. The list box contains 2
columns...UnitID (hidden - column width 0") and UnitName. UnitID is the
bound column that stores back to a table. I capture UnitID due to
relationships set up within the database. My question is on subsequent
forms, queries, and reports I would like to display the UnitName that
corresponds to the UnitID that was captured in the table. Is this possible
to do? I know I can use code to make a textbox on the original form display
UnitName and make it bound to a field in the table, but I feel that would be
saving duplicate information and wasting space.

Thank you for your help

 

[Jerry Whittle]

You could join the tables at query level to display the UnitName. This may
cause updating problems if you plan on using queries or forms to modifiy the
data.

You could also use DLookUp on an unbound text box on forms to show the
UnitName. It could be a little slow.