Subform ListBox Linked to Field in Parent Table

G

GeoffreyB

Good Afternoon,

I have a list box in a subform that I would like to display only data
that corresponds to the Parent Table Record. Essentially, I would like
the ParentTableID be linked to the ParentTableID of the subform and
then query that information in such a way that only the records in the
subform linked to the parent table ID show in the list box. Any help
given would be greatly appreciated. Thanks!

Geoffrey
 
T

TonyT

Hi GeoffreyB,

If you link the Main form and the subform using the LinkMaster/Child field
options, in properties, the subform should automatically update to show only
*related* information, thus if the listbox is bound to your datasource by
ParenTabletID, it will show only the records you want.

hth,

TonyT..
 
Top