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.
Thanks for your help.
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.
Code:
IIf([Forms]![frmDashboard]![Location]="All",Like "*",[Forms]![frmDashboard]![Location])
Thanks for your help.