Wild Card in Criteria from form 2

[ztm]

Please help!
I've been struggling with this for an eternity! I have a query that gets its search criteria from a combo box on a form. I'm trying to make it so that if the user selects an item in the combo box, the query returns results based on that item. But, if they leave the combo box empty, all records are returned. The query works if I select an item, but if I don't, I get zero records returned. This is what I have in the criteria field.

IIf(IsNull([Forms]![formname]![Combo]),"*",[Forms]![formname]![Combo])

I've tried all kinds of variations of the wildcard using the words Null, like, etc. and all I get is zero records returned.

 

[mharroff]

try adding a new column to your query as follows:

in the FIELD box type: IIf(IsNull([Forms]![form1]![Combo])=False,[YourFieldNameHere]=[Forms]![form1]![Combo],[YourFieldNameHere] Like "*&quot

unclick the SHOW box and set your CRITERIA to <>False

 

[ztm]

You are a GOD! I would have never thought of doing it that way. It worked perfectly. Thanks very much!

 

[dominicgingras]

a

 

[dominicgingras]

I know this is a old post but this is a little bit like what I am tring to do.

I have use this technique to filter a from using several combo boxes.

After filling up the combo box and clearing then. I get:

The applyfilter action was cancelled. Erro code

So I get out of the form and get in and every thing works again.

Strange!!!!

I would use help