Qury linked to Form with empty value

[ot070707]

Hi,
I have created a query linked to combo boxes on a user input form with [forms]![inputform]![comboxx] as my criteria.
This works fine until one of the combo boxes referred to is empty.
In this case, I want to return all records, but the query returns no records at all.
I have tried using iif(isnull([forms] etc, but I can't get this to work.
Please can someone assist?
Regards,
Mark

 

[John Big Booty]

Try the following as your criteria;

Like (IIf(IsNull([Forms]![FRM_FormName]![ComboName]),"*",[Forms]![FRM_FormName]![ComboName]))

 

[John Big Booty]

....and here's a sample DB.

 

[ot070707]

Re: Query linked to Form with empty value

Thanks.
I've tried that but it still returns no records.
I have also tried using Like "*" as well as just "*" but that doesn't work either.

 

[John Big Booty]

Have you examined the sample I posted?

 

[ot070707]

Didn't see that sorry.
I can't look at it at the moment due to my employer's firewall restrictions.
I'll have a good look tonight when I get home.
Many thanks.
Mark

 

[ot070707]

Hallelujah!
I had a look at your attachment and I was missing the 'Like' at the beginning.
It now does exactly what I wanted.
Many thanks again.
Have a good weekend.
Mark

 

[John Big Booty]

Glad you got it sorted