Filter forms

[D.Mair]

Well what I want to do is filter the Field [Completed] to show the records where that field is null. I want to have 2 buttons to click the first to apply the filter the second to remove the filter.
I can do some of it


Private Sub Command215_Click()
Form.FilterOn = True
End Sub

Private Sub Command218_Click()
Form.FilterOn = False
End Sub

I don't know how to tell it to filter the [Completed] is null part this is probably very simple but I am very confused

Thanks to all who read this and even more thanks to all who reply

 

[chrismcbride]

Use the ApplyFilter method to limit the form's records and the ShowAllRecords method to clear the filter. Both are methods of the DoCmd object. Try help for syntax
HTH
Chris