I have a form on my database (Customer) that is a drop-down list that allows the user to select one customer code.
I have a query that I want to filter my data table based on what the user selects in the customer form (or if blank, returns all customer records).
Here is my current formula in my query:
Code:
Like IIf([Forms]![IMDB]![Customer]="","*",[Forms]![IMDB]![Customer])
If a certain customer code is selected on the form, it does return results for that customer. However, my issue is when the form is left blank--it returns nothing but I want it to return all results. Am I using the wildcard incorrectly? I also tried IIf(isblank([Forms]![IMDB]![Customer]).... but that didn't work either
Thanks in advance!