Help with returning nulls on cbo selection

[smdemo]

I have a search form and when (blank) is selected from one of my fields I am having a hard time getting the query to return all fields that are not null. If nothing is selected, return all records. If a name is selected, match the name.

Logic tells me to write it like below, but I know it does not work due to the Is Null inside the IIf, but I have no idea how to write it correctly

IIf([Forms].[Search].[Reviewer]="blank",([Data Results].[Reviewer]) Is Null,[Forms].[Search].[Reviewer]) OR [Forms].[Search].[Reviewer] Is Null

Does anyone have a solution to this?

Thanks!

 

[dhookom]

Where is this, in the query?
Typically in a query, you would use:

[Forms]![Search]![Reviewer] Or [Forms]![Search]![Reviewer] Is Null

Duane
Hook'D on Access
MS Access MVP