Remove a filter

setis

Registered User.
Local time
Today, 02:54
Joined
Sep 30, 2017
Messages
127
Hi all,

Somehow I managed to save 3 of my forms with a filter on it that I can't remove now.

As you can see on the uploaded pics, the "No filter" on the record selector is greyed out and on the form properties, there is no filter applied.

The Record Source for the form is a table, not a query and I open the form from the objects menu.

Any idea how to remove the filter?
 

Attachments

  • filter.PNG
    filter.PNG
    2.9 KB · Views: 93
  • filter2.PNG
    filter2.PNG
    2 KB · Views: 85
the filter can be there, but not on.
to make sure its off, in form load event:

me.filterOn = false
 
the filter can be there, but not on.
to make sure its off, in form load event:

me.filterOn = false

Thank you! Unfortunately it didn't make the trick for me. I get the same result..
 
I think that I found the problem. The Data Entry property on the form was set to "Yes" :banghead:
 

Users who are viewing this thread

Back
Top Bottom