Filter Form On and Off From Multiple Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like a form to have a form named [Gopher One] open with this filter
on, but have the user be able to turn the filter on and off. The Filter on
should have the following fields (all date fields) as null.

Office Cleared
Field Cleared
Dispatched

The Filter off should display all records.
 
Figured it out:
DoCmd.ApplyFilter "", "([Office Cleared] Is Null) And ([Field Cleared] Is
Null) And ([Dispatched] Is Null)"
 
Back
Top