G
Guest
How can I remove a where condition from the filter of a form on closing it?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JohnFol
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
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