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.
December 17, 2008 3:38 PM
December 17, 2008 9:27 PM