Apr 25, 2015, 4:09:15 PM4/25/15
Microsoft Access 2013
Hello! I am trying to get QBF to work with three value ComboBox:
Pending Work, No Work Required, and All Records
Record values include:
CboStatus has two dropdown values:
If Pending Work is selected, it should render column values:
- Differed until later time
- Null values
If ALL is selected, it should render ALL records.
What I have tried.
Control Name: cboStatus
Criteria on Status Column of query:
IIf([forms]![MyForm]![cboStatus]="Pending Work",Is Null or "Differed until later time","*")
Thanks for any help with this!