Query getting info from Field on Form

[alloyd1]

I am really having an issue... here is what I want to do..

Like IIf([Forms]![frm_Reports]![fAgent] Is Null,Is Null Or Like "*","*" & [Forms]![frm_Reports]![fAgent] & "*")

If the form has an fagent in it, it works perfectly, but if not, it returns no results. If I run just the --- Is Null Or Like "*" --- it works and returns all records. Can someone tell me what I need to change.

 

[stopher]

Try:

nz([Forms]![frm_Reports]![fAgent],"")="" Or Like "*" & [Forms]![frm_Reports]![fAgent] & "*"

hth
Chris

 

[alloyd1]

Stopher, that worked PERFECT! I tried the NZ before, but not how you did it. I knew it was something simple, just could not see it. Thank you for opening my eyes.