QBF for three categories of records: Pending Work, No Work, and ALL

8 views
Skip to first unread message

Robert Bollinger

unread,
Apr 25, 2015, 4:09:15 PM4/25/15
to
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:

Pending Work
ALL


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!

RBollin
















Reply all
Reply to author
Forward
0 new messages