One Subform, Two combo boxes

[Joe Williams]

I have a main form with a subform that lists sales. Three subform fields are
saleID, productID, and and salespersonID

I would like to have a combo box (s) so that I can either select productID
and see all the salespeople that sold a particular productID, OR I would
like to be able to select salespersonID and see all the productIDs that this
one person has sold.

I have done this with one simple combo box, buit never where you could be
able to select one onf two criteria.

How can I accomplish this, and is there a more efficient way than two combo
boxes?

Thanks

Joe

 

[Penguin]

Try this link:

http://www.mvps.org/access/resources/downloads.htm

Scroll down to QBF and download and view the example.

Hope this helps.