title: Filtering a MS Access form between dates and a third field
body: <p>I am trying to filter a form between two dates and not equal to a third criteria. All three criteria's are in form fields. Note that this is not a "or" statement but rather all three criteria's must be met to return a record. Below is the statement that I have set on click for a form button.</p>
  
  <pre><code> Me.Filter = "[dt] BETWEEN #" &amp; Me.StartDate &amp; "# AND #" &amp; Me.EndDate &amp; "#"
   Me.FilterOn = True
  </code></pre>
  
  <p>I need to add the third criteria from a form field in the same form as "List54" which has a control source of [Status]. The valid status for returning a record would be not equal to "Closed". Note that "Open" or null field would be alternatively acceptable to return a record.</p>