ComboBox, select null?

[offie]

I have comboboxes, depending on the user they might want to be left blank. When I click to look through them I can no longer leave them black.



I went back to the table that has what the combo box shows and inserted <N/A>

So for criteria, I tried (just using names since with nav forms the names are super long)
IIF(Combo<>"<N/A>", Like "*" & Combo & "*", "*")

But I get no records when I run the query

Suggestions? Are there other ways of doing this?

[MrSmith]

I use Access 2007 so this might not be the case in 2010, but you should be able to backspace out of any selection in a combo box leaving it blank.

For a date range in which I want to allow for blanks:

>=[Forms]![Start Form]![Text85] And (<=[Forms]![Start Form]![Text88] Or Like IIf(IsNull([Forms]![Start Form]![Text88]),"*",[Forms]![Start Form]![Text88]))

In this scenario a date must be entered into Text85, but if Text88 is left empty it will return all information after the first date. This could be adjusted to allow for the first date to be blank as well if needed.

[offie]

Thanks! Just what I needed, didn't know about the backspace, silly me.