Pass "Is Not Null" In parameter Query 1

[cutestuff]

What's the right syntax for the following:

Like IIf(IsNull([Forms]![frmDReport]![cboType]),"*",Is Not Null)

I can't get the "Is Not Null" portion to work. Basically, if the user does not select a type in the combo box i want it to display all but if they do not i want it to display everything that is not null in the field.

thanks in advance...

 

[PHV]

Like "*" OR [Forms]![frmDReport]![cboType] Is Null


Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cutestuff]

Thank you so very much!