Showing records with a null value on Form (1 Viewer)

[gbanks]

Ok this null value thing is killing me. I have a parameter query that works great. I know if I use Is Null in the criteria field it will show me this. The problem is I made a search form which the users type the value in and it opens a form based on the parameter query, the parameter on the query is [Forms]![Search_frm]![txtClosed]. If they type a date in here it opens the form and shows the user all the closed records. The problem is they want to see all the records that have no value or Null. I've tried eveything to make this work. I'm ready to jump!! Just kidding. Is there a way to do this with out creating another query. Thanks a bunch!!!

 

[FoFa]

Can you use NZ in the criteria? If so try something like:
NZ([Forms]![Search_frm]![txtClosed],"@")
Then if the user selects empty (open? dates) use "@" in the criteria.

 

[gbanks]

Thank you SOOOOOOOOOOOOOOO MUCH!!!! I got it working just the way I needed it to. Awesome!!!!