Question Selecting all fields if form field is blank

[lynxbci]

Hi,
I have a select query and it runs dpendant on the contents of 3 combo boxes, if all three are populated. However if only 2 are populated i want it to run the query and use ALL or whatever for the 3rd criteria.

Select criteria is:-
[Forms]![frm_pricefinder]![level1]

Tried this:-
iif([Forms]![frm_pricefinder]![level1] is Null,like "*",[Forms]![frm_pricefinder]![level1])

But to no avail

Anybody help please

thanks

 

[Brianwarnock]

Read this

Brian

 

[lynxbci]

Thanks that sorted it. Much obliged