Combo Box - Select */All if null?

[richand1]

Hi,

I've got a combo box that uses a column in a table to filter out records in a subform/query. The column is for the promotion mechanic. I now need to create another combo box that will filter the subform still more by selecting the vendor who is "hosting" the promotion. My only problem here is, if we want all "3 for 99p" promotions regardless of vendor, leaving the vendor combo box blank mweans that the query doesn't return any records.

I've tried messing around with an if statement in the criteria of the vendor column in the query, but to no avail.

Is there a way to have a record within the vendor combo box that says "All" as a default value and, when left or selected, requeries the query so that all values are returned?

Thanks all
Rich

 

[TheAceMan1]

How are ya richand1 . . .

Have a look here How to add '(all)' to a combo box or a list box control

See Ya! . . . . . .