So I have a Textbox called SearchParameters and two more called StartDate and EndDate on a form. I got the dates to work fine, using
Code:
Between Nz([Forms]![frmSampleStatus]![StartDate],#1/1/1900#) And Nz([Forms]![frmSampleStatus]![EndDate],#1/1/2200#)
Now I want to find anything with those dates and null so in the or criteria I put Nz([Forms]![frmSampleStatus]![SearchParameters],Is Null). I even tried the SearchParameter by itself and all I get is #Name? all across the subform datasheet. Ive tried to make the textbox "Is Null", "Is Not Null", "Null", Null, and so on... I havent gotten anything to show both the dates I want and the ones that dont have dates.