Form/Subform

[Guest]

How do I create a subform that is filtered by multiple controls? I have to
filter this by 3 different controls. All 3 of these controls are tied to
different tables. They all have relationships between each other but I don't
know how to create this. I have created a subform that is driven by one
control but I don't know how to create multiple control filters. These
filters all reside in different tables. Can anyone help me work through this?

 

[John Vinson]

How do I create a subform that is filtered by multiple controls? I have to
filter this by 3 different controls. All 3 of these controls are tied to
different tables. They all have relationships between each other but I don't
know how to create this. I have created a subform that is driven by one
control but I don't know how to create multiple control filters. These
filters all reside in different tables. Can anyone help me work through this?

Set the Master Link Field to

Controlname;AnotherControl;AThirdControl

and the Child Link Field to

Fieldname;Fieldname2;Fieldname3


John W. Vinson[MVP]

 

[Guest]

Where do I find the child link and master link fields? Are these on the
subform? Also, are the controlname & fieldname the same thing? Forgive me for
asking all this as I'm a little new with subforms.