Criteria in query

[geralf]

I have a query which is a source for a listbox. I have a criteria in this query. The criteria is set from two controls on the form. After setting the criterias in the form, the query is re-quyered. This work fine, except for when one or two of the criteria controls are blank (Null). In this case I would like to have no criteria for the query, so all records are returned. How can I do this?

Thanks in advance for any help

 

[dcx693]

Check out this post: Query to return all record when nothing is entered.

 

[geralf]

Thanks for your help and link. Now I know how to use the null as a criteria.

Thanks