toggle filter always on - on database launch

[Dee]

Hi,

I ahve a database and when it opens the toggle filter is always on to the
last search I did, can anyone tell me if there is a way to turn this off?

Thanks!

 

[Allen Browne]

I have a database and when it opens the toggle filter is always on to the
last search I did, can anyone tell me if there is a way to turn this off?

What version of Access? And what context?

If this is Access 2007, open the object (form?) in design view.
Set the Filter On Load property to No.
Clear whatever is in the Filter property.

 

[Dee]

Hi Allen,
I have just changed from Access 2003 to 2007. When I open the particular
form the toggle filter button is highlighted and it is showing the records
for the last search I did. Even if I turn off the filter and hit save and
reopen the database the filter is still on and showing the records for the
last search I did.
I hope I explained this ok!
I have a few other databases that I use and am not having this problem with
them so I am assuming it's a setting somewhere, I have checked the Access
options and cannot find what it might be.
Thanks a million!

 

[Maurice]

Dee,

In addition to Allen's answer try to take a look at the following. If it's a
table that is being used for the form take a look at that table.

In designview of the table click the properties button in the ribbon. Now in
the properties of the table look at the option "Filter On Load" if that is
set to yes. If so set it to No and save the table. See if that works.

hth

 

[Allen Browne]

Did you locate the new Filter On Load property?

Sure sounds like the culprit.

 

[Maurice]

Table properties stuff I have to teach for MCAS certification ;-)
Had me surpised there for a minute too...

 

[Don Gatto]

Hi there,

Yeah, but what if its' Control Source is a query?

I've got a database that was created in Access 2003, and there's the same problem: filter is stuck on a form when I open it in Access 2010. I can remove it, but when I return to the form, it's there again.

Thanks in advance!