asked on
[forms]![fr_DailyWOMYPInspectionSelection]![cmb_AnnexDrop]
I also need to see all records from the query not just when I select individual annexes, and this is where I am having a problem. Currently this is the code I am using as criteria in the query, but its not returning any records when in the dropbox I select empty option, or even a * option.
IIf(IsNull([forms]![fr_DailyWOMYPInspectionSelection]![cmb_AnnexDrop]),"*",[forms]![fr_DailyWOMYPInspectionSelection]![cmb_AnnexDrop])
Can anyone help me with what code I need to have these annexes displayed individually and all at the same time?