Subform Linking To Multiple Master Fields

[Ange Kappas]

Hi
I have a subform which is based on a query named ACCOUNTS
with the fields:
Name
Company
Arrival (which is date field)
Departure (which is date field)
Charge

In the Form named ACCOUNTS SEARCH I have controls named:
Pick Company (Which is a combo box)
Pick Arrival (which is date field)
Pick Departure (which is date field)

I want to set the criteria in the controls Pick Company, Pick Arrival and
Pick Departure to filter out in the subform the records I want.

Thanks

 

[KARL DEWEY]

You can use more than one field in Master and Child linking fields.
I have not done it but first try with commas as separators.
The fields must be of same DataType like this ---
Text, DateTime, Number-long integer --- Master
Text, DateTime, Number-long integer --- Child

 

[Ange Kappas]

Thanks it works
Ange

You can use more than one field in Master and Child linking fields.
I have not done it but first try with commas as separators.
The fields must be of same DataType like this ---
Text, DateTime, Number-long integer --- Master
Text, DateTime, Number-long integer --- Child