Qry values based on Cbo

[Jason]

I am trying to limit the data in my qry based on the values of a Combo box on
a form. The trick to it is that if the Combo is left blank I would like it to
return all records. Is this possible? I have tried the following but it does
not work, Any help is appreciated.

=IIf([Forms]![Frm_Clinical_EmployeeSelect]![Combo15]="","",=[Forms]![Frm_Clinical_EmployeeSelect]![Combo15])

 

[KARL DEWEY]

Try this ---
Like [Forms]![Frm_Clinical_EmployeeSelect]![Combo15] & "*"

 

[Jason]

That returns the data when the Cbo has data in it but does not return all
records when it is empty

Try this ---
Like [Forms]![Frm_Clinical_EmployeeSelect]![Combo15] & "*"
--
KARL DEWEY
Build a little - Test a little

I am trying to limit the data in my qry based on the values of a Combo box on
a form. The trick to it is that if the Combo is left blank I would like it to
return all records. Is this possible? I have tried the following but it does
not work, Any help is appreciated.

=IIf([Forms]![Frm_Clinical_EmployeeSelect]![Combo15]="","",=[Forms]![Frm_Clinical_EmployeeSelect]![Combo15])

 

[KARL DEWEY]

Try this ---
[Forms]![Frm_Clinical_EmployeeSelect]![Combo15] Or
[Forms]![Frm_Clinical_EmployeeSelect]![Combo15] Is Null

--
KARL DEWEY
Build a little - Test a little

That returns the data when the Cbo has data in it but does not return all
records when it is empty

Try this ---
Like [Forms]![Frm_Clinical_EmployeeSelect]![Combo15] & "*"
--
KARL DEWEY
Build a little - Test a little

I am trying to limit the data in my qry based on the values of a Combo box on
a form. The trick to it is that if the Combo is left blank I would like it to
return all records. Is this possible? I have tried the following but it does
not work, Any help is appreciated.

=IIf([Forms]![Frm_Clinical_EmployeeSelect]![Combo15]="","",=[Forms]![Frm_Clinical_EmployeeSelect]![Combo15])