Change which query opens form

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

Bonnie

A02. I have contracts with various Service Agreements (SA)
dictating fees to charge. I have a query for each SA. I
have a billing form that all queries work on.

Can I (How can I) have my form open with it's record
source qSA01 this time and qSA03 next time depending upon
which SA is selected for each contract?

Thanks in advance for any help/advice I can get!
 
Hey,

You could try using a generic subform. Change the record
source of the subform according to a field (or set of
fields) from the master form. So if the field(s) meet a
certain criteria they show information for qSA01 else shoq
information on qSA03.

Regards,
Eric
 
Back
Top