V vagman Member Local time Today, 21:33 Joined Nov 10, 2021 Messages 45 Nov 24, 2021 #1 I have an access 2000 db and when I open a form from another form the filter remains in the properties How can I clear the field of the form ?
I have an access 2000 db and when I open a form from another form the filter remains in the properties How can I clear the field of the form ?
arnelgp ..forever waiting... waiting for jellybean! Local time Tomorrow, 02:33 Joined May 7, 2009 Messages 20,363 Nov 24, 2021 #2 bring your form in design view and remove the filter on its property.
gemma-the-husky Super Moderator Staff member Local time Today, 19:33 Joined Sep 12, 2006 Messages 16,051 Nov 24, 2021 #3 Changing a filter is a design change. If you use a filter in a form and save the design when the close the form, it might well save the filter. If you use an .accde it can't save the design change.
Changing a filter is a design change. If you use a filter in a form and save the design when the close the form, it might well save the filter. If you use an .accde it can't save the design change.
Gasman Enthusiastic Amateur Local time Today, 19:33 Joined Sep 21, 2011 Messages 17,081 Nov 24, 2021 #4 vagman said: I have an access 2000 db and when I open a form from another form the filter remains in the properties How can I clear the field of the form ? Click to expand... Does not mean the filter is in effect, just that was the last filter? I've noticed this before.
vagman said: I have an access 2000 db and when I open a form from another form the filter remains in the properties How can I clear the field of the form ? Click to expand... Does not mean the filter is in effect, just that was the last filter? I've noticed this before.