Hello,

I am building an Order Entry system that tracks orders for brokers and the contacts that work for the broker. The contact form is a subform of the broker form.

Currently, the Order Entry form opens correctly for the broker using the macro with the where clause: "[numAccountID]=[Forms]![frmCompanyAccount]![numAccountID]".

I would also like the order entry from to open to the correct contact. The contact field would be:{numContactID} = [Forms]![frmCompanyAccount![CompanyContact]![numContractID].

My question is how do I make the order entry form open up to the correct broker and contact. The order entry form has the two fields numAccountID and numContactID.

Thanks

Use the AND operator:

[numAccountID] = Forms.[frmCompanyAccount].Form.[numAccountID] AND [numContactID] = Forms.[frmCompanyAccount].Form.[numContractID]


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division