subform combo to filter based on other subform...technically mainform's other subform records.

G

Guest

This is probably a quick one. I have a subform for Orders.

One this there is an address drop down, so you can pick the address for
the order. The main form is for the customer.

So a customer has multiple orders. There is another subform on a tab
for addresses. A customer may have multiple addresses.

The combo box on the orders subform should filter to only the address
on the address subform. More precisely, the address combo should
filter to just the addresses for that customer.

Any ideas on how to make this work?

I'm under the gun to get this done.

Thanks for any help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top