toggle filter always on - on database launch

D

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!
 
A

Allen Browne

Dee said:
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?
Click to expand...

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.
 
D

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!
 
M

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
 
M

Maurice

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