Wildcard Filter for a Form

[Moxioron]

Hello.

I have a combo box form that I am using in a query. It works great, except I want it to return all results if the combo box is left blank.

The criteria in the query for Associate Name reflects:
[Forms]![frm_Associate Name (Summary Report)]![Combo1]


I have tried Like [Forms]![frm_Associate Name (Summary Report)]![Combo1]&"*"

To no avail...

Any words of wisdom? Thanks.

 

[boblarson]

It should be:

[Forms]![frm_Associate Name (Summary Report)]![Combo1] or [Forms]![frm_Associate Name (Summary Report)]![Combo1] Is Null

 

[Moxioron]

Thank you for your response.

That didn't return any results though.

 

[boblarson]

Just remember that if you go into a combo and select the value and hit your backspace or delete key it doesn't make it null. It just has an empty string. So, you may need to change to this:

[Forms]![frm_Associate Name (Summary Report)]![Combo1] or Len([Forms]![frm_Associate Name (Summary Report)]![Combo1] & "") = 0

 

[Moxioron]

Thank you. That did the trick.