Subform ListBox Linked to Field in Parent Table

  • Thread starter Thread starter GeoffreyB
  • Start date Start date
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
 
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..
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple subforms 0
Filter main form to records with no related records in subform,maintain updateable recordset 4
Single parent form contains multiple instances of the same subform 8
subform question 2
Many to Many junction table and subforms 1
New record in subform 2
Code to pass value from subform to control on parent? 3
Access 2003: Finding a parent subform control 2

Back
Top