using query conditions to return a specific value or all values

[Guest]

using Access 2002...
I am trying to construct a query, using criteria which is selected from a
combo box on a form. If a value is selected in the combo box, then the query
will return only the value selected, but if no value is selected in the combo
box (therefore the combo box has a null value) then the query will return all
values. Using an IIF statement in the query criteria field, I can get the
query to return the appropriate results if a value is selected from the combo
box, but I am not able to return all values if nothing is selected in the
combo box

 

[Ken Snell [MVP]]

Use this as the criterion expression:

[Forms]![FormName]![ComboBoxName] Or [Forms]![FormName]![ComboBoxName] Is
Null

 

[Guest]

Thank you very much Ken
Your help is much appreciated!
AC

Use this as the criterion expression:

[Forms]![FormName]![ComboBoxName] Or [Forms]![FormName]![ComboBoxName] Is
Null
--

Ken Snell
<MS ACCESS MVP>

using Access 2002...
I am trying to construct a query, using criteria which is selected from a
combo box on a form. If a value is selected in the combo box, then the
query
will return only the value selected, but if no value is selected in the
combo
box (therefore the combo box has a null value) then the query will return
all
values. Using an IIF statement in the query criteria field, I can get the
query to return the appropriate results if a value is selected from the
combo
box, but I am not able to return all values if nothing is selected in the
combo box