Display data from related table

  • Thread starter Thread starter Darwood
  • Start date Start date
D

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.
 
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
 
Back
Top