form search query and is null

[ShostyFan]

I have a basic search form that sets query parameters.
The query criteria is: [Forms]![Search_Form]![cmbo_Category]
And this works fine as long as a value is set in the search form, if no value is set there are 0 results.
I want the user to be able to select a category or leave the category blank to return all values.


Sadly this does not work: [Forms]![Search_Form]![cmbo_Category] OR is null

[Gicu]

use: Like Nz([Forms]![Search_Form]![cmbo_Category],"*")

Cheers,
Vlad

[ShostyFan]

disco!
worked perfectly! Thanks.

[Minty]

You were close, if you use
[Forms]![Search_Form]![cmbo_Category] OR [Forms]![Search_Form]![cmbo_Category] is null
it will work, and is more efficient that the wildcard.