Filter form with query

[lotarugg]

Hi have been trying all day to do this simple task. I want to filter a form to show records that have a certain date field blank. I'm using a query (as a macro does not seem to like Is Null or Null or any other syntax of Null in relation to a date). I have linked the query to a button, but on press it opens a sheet of the results and I cann't find how to make it simply filter the records on the form. Please tell me there is a simple solution to this.

Cheers

 

[boblarson]

First, remove any criteria from the query for the form that you are opening.

Second, we will create a macro that looks like this:
(if you have Access 2010 then it will look quite a bit different than this)

 

[lotarugg]

Brilliant! Thanks very much.