Trouble with IIF

[dixxy12]

I am trying to return a value for a field and also check if the feild is NULL at the same time with this:

IIf(nz([Forms]![frmInstallSchcedule]![cboInstaller].[Value],"")="",[installer],[Forms]![frmInstallSchcedule]![cboInstaller].[Value])

if the feild 'installer' has no data, then it does not show does records. I would like to see those records anyway, so that i know which are null.

what am i doing wrong

 

[dixxy12]

Resolved it!!!!...use the IIF in the quwery feild insrtead of the query criteria...

seems to work fine

 

[dixxy12]

ooppss....crash and burn....

does not work so good after all

using this in the query feild

Expr1: IIf([installer],[Installer],"NOT ASSIGNED")

works good to return all, but when i try to filter ti based on the forms combo box then it only returns all of the records, not filtered based on the form selection box...

any help?