Removing a filter

  • Thread starter Thread starter Guest
  • Start date Start date
When you apply a filter and close the form you are prompted to save it. If
you say "No" the filter is not saved
If you are closing the form in code

DoCmd.Close acForm, Me.Name, acSaveNo

then set the .Filter property to "" before doing it
 

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

applying concatenate filter 1
Filter Form doesn't close 2
Form Filter will not delete 2
Filter tabular form by combo box 0
Resetting the form filter filter for a new report 4
filtering a form based on a filter on an open form 2
Acc2003 need filter on always or removed (can't do) 10
Filter Form, Print Report based on Filter 1

Back
Top