Iif

[HOJU15]

((IIf(IsNull([forms].[SEARCH]![SECTION]),[Located in].[SECTION]=’*’ ,[located in].[SECTION]=[forms].[SEARCH]![SECTION]))<>False)

I need the true part of the statement to all return all records null and those with a value, what I have there is not workin

 

[Bryan F]

IIf(IsNull([forms]![SEARCH]![SECTION]),"[Located in].[SECTION]=’*’" ,"[located in].[SECTION]=[forms]![SEARCH]![SECTION]")


try this one

 

[Pat Hartman]

You cannot change the structure of a query in this way. Change the selection criteris to:

=[forms].[SEARCH]![SECTION] Or IsNull([forms].[SEARCH]![SECTION])