Hello, I have a parameter query which is filtered by a form combo box. There are 4 tables with appropriate relationships and joins in the query. I have the following criteria in one of my fields. Like (IIf(IsNull([Forms]![Filte
r Swichboard]![cmbBusinessUn
it].[text]
),"*",[For
ms]![Filte
r Swichboard]![cmbBusinessUn
it].[text]
)).
If the combo box is empty this filter returns ALL records unless the Business_Unit field IS NULL. So I tried Like (IIf(IsNull([Forms]![Filte
r Swichboard]![cmbBusinessUn
it].[text]
),Like "*" or Is Null,[Forms]![Filter Swichboard]![cmbBusinessUn
it].[text]
)). Which then returns no records.
What I am trying to do is when the combo box has no value return ALL records from the query including where the Business_Unit field is null. Help is greatly appreciated.
I also tried Like (IIf(IsNull([Forms]![Filte
r Swichboard]![cmbBusinessUn
it].[text]
),"*",[For
ms]![Filte
r Swichboard]![cmbBusinessUn
it].[text]
)) Or Is Null which then returns all records in the filter and records which are NULL. thanks
Start Free Trial