Two Queries

[jcruzAME]

Okay, so at the moment I have a combo box that queries all the advisors for a certain company. After that updates, I want to run a query on the clients table to populate only the clients of that advisor but I'm having trouble linking the two.

The Contact (advisors) table has a ContactID, which is FirmContactID in the Clients table.

Any tips on how to get this query to work?

Thanks in advance.

 

[John Big Booty]

What you are looking for is a cascading Combo Box set. Also search this forum for samples and further discussion on the topic.