I have a query that uses a field on a form to filter what information gets displayed. This is simple I know but what I need it to do is display all records if I don't enter anything in the field on the form.
I tried putting the following IIF statement in the Criteria: IIf([Forms]![ContractPOSchedule]![PONoVar] Is Not Null,[Forms]![ContractPOSchedule]![PONoVar],([tblContractPOs].[ContractPO]) Like "*")
If I enter something in the field on the form then it only displays those records but if the field is blank then nothing gets displayed. Do I have my syntax wrong in the IIF statement?
Any help would be greatly appreciated.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!