Passing a parameter to a query (1 Viewer)

I have aform which uses a query as the data source. The query uses a couple of fields on the form as parameters.
eg the criteria on the customer field in the query is [forms]![Customer]![txtCustomer]. I want to override this to pick all customers. Is there a clever way of doing this or am I going to have to have potentially 2 forms and 2 querie?

In your query criteria use the following to return all values if the txtbox is null;

Minty said:

In your query criteria use the following to return all values if the txtbox is null;

Code:Copy to clipboard

[forms]![Customer]![txtCustomer] OR [forms]![Customer]![txtCustomer] Is Null

Click to expand...

Thanks for this but just discovered how to use the filter!