Display Text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

accessuser1308 - 09 Apr 2008 14:05 GMT

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

Reply to this Message

Jerry Whittle - 09 Apr 2008 14:58 GMT

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.

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> 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
[quoted text clipped - 7 lines]
>
> Thank you for your help

Reply to this Message