Blank field in form

[Bvdman32]

I have a query that gets some criteria (City and State) from a form.
I have the State field set up as a ComboBox connected to a local
table
I created. If a user was to type in a City (i.e. "Springfield") and
then leave the State field empty, then the query would have no
results.

How do I make the query so that if one of the fields on the form is
left empty it will run for all possibilities (i.e. look for all
Springfields in any state)?

 

[Duane Hookom]

It would help tremendously if you had provided the SQL view of your query.
Without that I can suggest you might use a where clause like:

WHERE [State] = Forms!AForm!cboState or Forms!AForm!cboState Is Null;