I'm using a value from an unbound Form Combo Box to limit my Query.
I'm using this expression to limit by City
Like "*" & [Forms]![frm_Search]![cmb_CITY ]& "*"
My Table contains many rows with Null Values for this Field
When I use the above expression the query does not show rows with null
values even when the Form Combo Box value is Null.
I need a query expression that will run only when there is a value in
the Form Combo Box.
If there is a value in the Form Combo Box then limit to that value
If the Form Combo Box is Null do nothing and return all rows
> I'm using a value from an unbound Form Combo Box to limit my Query.
>
[quoted text clipped - 9 lines]
> If there is a value in the Form Combo Box then limit to that value
> If the Form Combo Box is Null do nothing and return all rows
Try...
= [Forms]![frm_Search]![cmb_CITY ] OR [Forms]![frm_Search]![cmb_CITY ] Is Null
(assuming the only reason you were using "*" was to deal with no entry in the
form).

Signature
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com