Avatar of toalexsandr
toalexsandr
Flag for United States of America

asked on 

How to view all records from combo box on form

I have a combo box on a form that passes 6 different annex number sets as parameters to the linked query. These numbers are 0600000, 1502000, 1602000, 1700000, and 1800000. The following line works perfect when selecting those numbers individually and after update, subform query gets refreshed and updated.
[forms]![fr_DailyWOMYPInspectionSelection]![cmb_AnnexDrop] 

Open in new window

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])

Open in new window

Can anyone help me with what code I need to have these annexes displayed individually and all at the same time?
Microsoft Access

Avatar of undefined
Last Comment
toalexsandr

8/22/2022 - Mon