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)"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Search Box and Filters 1
Need combo box to refresh when moving to new record 2017 1
filter frustration 3
Error Message "Cannot apply filter on one or more fields specified 0
filter on and off 1
Passing Field Names between forms 3
search criteria filter 1
Prohibit Filter Off 3

Back
Top