Link 2 Subforms (Access 2003)

Topic

New Reply

Is it possible to link 2 subforms so that when I click in the record of the first subform it displays all the records that belong to the selected item in the selected subform.
Thanks for any help or suggestions.

Reply | Quote

Replies

It’s pretty easy –
step 1 Put a text box on the main form, this does not need to be visible. set its control source to be the field on the first subform. eg – =Subform1.Form!SupplierID
step 2 use this textbox as the Link Master Field on the second subforms.

Reply | Quote