Allowing blanks with multiple combobox selections

[Guest]

I have a form that uses several combo boxes (Designer, Salesperson, and
Style) to select data. My users have requested the ability to leave one or
more of these fields blank. (For example, leaving Style blank would pull all
records for the particular Designer and Salesperson, no matter what the style
is.)
Currently, leaving one of these fields blank only yields results if there
are records that otherwise match, but have a null value for the blank
selection.

I could really use help with this. I can post code if needed...
Thanks in advance

 

[Guest]

Post the code, please

 

[Guest]

Resolved on my own just now, thank you.
I was using If statements to set value to a variable "Number"
and the Select Case to select the search criteria.


My error was in using
If Me![cboStyle] is null ...(etc)
rather than
If IsNull(Me![cboStyle]) ... (etc)

Thanks very much anyhow.

 

[Guest]

Oh, I see the problem, the etc should be in square brackets:
[etc]

Resolved on my own just now, thank you.
I was using If statements to set value to a variable "Number"
and the Select Case to select the search criteria.


My error was in using
If Me![cboStyle] is null ...(etc)
rather than
If IsNull(Me![cboStyle]) ... (etc)

Thanks very much anyhow.

Post the code, please