search form

[Darren Spooner]

I have a search form with 3 fields on it, I also have a query that has the
same fields as the form and in the Criteria section I put LIKE "*" &
[forms]![formName]1[textField] & "*" I each field. I have one field(field2)
that in the table is NULL, so when I enter data to the first field and
nothing in the other 2 fields it will only get the data that field2 is NOT
NULL.
how do I get the records that may have a NULL value in field2

 

[help]

try the NZ() function