query from combo

  • Thread starter Thread starter KKruz
  • Start date Start date
K

KKruz

I have a query in which I have criteria entered from several controls on a form
combo list
text field
date field

If one of the criteria is missing I get no records.

I have tried to use a IIf statement without success.
IIf(is null [combo],"",[combo])

I beleive it is failing because I am using "" which is setting the criteria
for that field as nothing along with the other fields and therefore resulting
in no records.

Is there another way to ignore blank input fields from the form and set the
criteria in the query grid?

Thanks,

Kurt
 
Back
Top