Subform Linking To Multiple Master Fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ange Kappas - 05 Feb 2008 18:30 GMT

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

Reply to this Message

KARL DEWEY - 05 Feb 2008 18:57 GMT

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

Signature

KARL DEWEY
Build a little - Test a little

> Hi
> I have a subform which is based on a query named ACCOUNTS
[quoted text clipped - 14 lines]
>
> Thanks

Reply to this Message

Ange Kappas - 05 Feb 2008 19:15 GMT

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.
[quoted text clipped - 20 lines]
>>
>> Thanks

Reply to this Message