Query Criteria with a wilcard

[RevJeff]

Hello,

I am trying to setup a query that looks at a ComboBox named "Location". If "All" is selected in the ComboBox, I want everything displayed in the query, but if a certain location is selected, then the query only displays that locations information. That part works fine. It's that "All" part that I am having issues with. Below is the code I have in the Criteria field in the query.

IIf([Forms]![frmDashboard]![Location]="All",Like "*",[Forms]![frmDashboard]![Location])

Thanks for your help.

 

[Minty]

You don't need the "All" , have it default to Null value, then in the criteria put the following

=[Forms]![frmDashboard]![Location] Or [Forms]![frmDashboard]![Location] Is Null

This will bring back all values if the combo is null, and can be repeated for multiple combo's.

 

[RevJeff]

That works perfectly! Thank you!