Parameter query based on 2 combo boxes

[kbestle]

I have researched all the Access sites that I know of and cannot find a solution to my problem. I want to have a form that has two combo boxes. One for specifing Buyers and one for Suppliers. I want to be able to filter records in a table using a parameter query. I also want to be able to have a "All" choice in each combo box. This will allow a user to select All buyers and all suppliers or a buyer and all suppliers or all buyers and one supplier. You get the idea. Using one works fine. Adding the second combo box returns no records. I was going to attach or post the database but do not see a way to do that.

Thanks for all help to come.

Kent

 

[lupins46]

To do it without the All option you can set the criteria like this:

forms!myformname!mycomboname or (Isnull(forms!myformname!mycomboname)=true).

If you have already created the All option in the combo then use:
forms!myformname!mycomboname or (forms!myformname!mycomboname='all').

 

[kbestle]

Thanks, This did the trick.

Kent