query from combo

[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

 

[Jeanette Cunningham]

Have a look at the downloadable sample search form on
http://www.allenbrowne.com/ser-62.html
It shows to grab the results from controls just as you are trying to do.

Jeanette Cunningham