Subform Linking To Multiple Master Fields

  • Thread starter Thread starter Ange Kappas
  • Start date Start date
A

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
 
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
 
Thanks it works
Ange


KARL DEWEY said:
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
 
Back
Top