Query criteria based on combo box if combo box null

[vicissitude]

I wonder if someone could help me with this one.....

If i tie a query criteria in 'column1' to the value in a combo box like this....

Nz([forms]![FormName].[comboboxName],[column1])

...then the query is filtered on the combo box or if the combo box is Null then the query gives all the results provided there is some value in the 'column1' field.

Is there a way filter on the combo box and to pull back all the results if the combo box is null and also to pull back all the results if 'column1' is also null?

Thanks in advance.

 

[John Big Booty]

Where you have a a mix of records that contain Null values and real values it becomes very difficult to deal with. The best strategy is to ensure that all records are populated with a real value, you can do this by setting a default value for each field.