Display data from related table

[Darwood]

How do I display data from a related table on my form. The recordsource of
the form is set to the main table. I don't want to create a subform to
display what is effectively the (lookedup) description for a foriegn key.

 

[Steve Schapel]

Darwood,

There are at least a couple of approaches to this. IMO the preferable
one is to base the form on a query which includes both the main table
and the related lookup table. The other is to use an unbound textbox
on the form with its controlsource set to an applicable DLookup()
expression.

- Steve Schapel, Microsoft Access MVP

 

[Darwood]

I went the DLookup route and it works great. Many thanks.