I am trying to get a query to return a record if an ID number is inserted in a form, otherwise to return all records if the form is blank. This is the code I am trying to use.
- =IIf([Forms]![Form Filter]![Text20]="isnull","*",[Forms]![Form Filter]![Text20])
I don't get an error message; however, I get nothing but a blank query every time, whether I insert an ID number or not.