Filter Problems with SP3

[Paul]

I'm running Windows 2000 SP4 and Access 2000 SP3

After installing SP3 my filters only work one time.

I have forms with many cmdButtons using docmd.ApplyFilter.
Since installing Access SP3 these buttons will only work
one time after opening the form. I have to close and re-
open the form after each search. This occurs on all forms
in all Access files.

We installted SP3 on 3 computers and they all have the
same problem. The non upgraded computers still work fine.

Any Ideas?

Thanks

Paul McCroskey

 

[dewayne]

Sorry to say this, but I'm glad to see someone else
haveing this problem. I am having the exact same problem
is this a known issue. We need help.

 

[Larry Linson]

Here's a workaround. Instead of applying a filter (they seem to be a little
quirky in other ways too, to me), create a WHERE clause, apply it to the
base SQL, and set the Form's RecordSource. Have a "Show All" command button
to remove the WHERE, as well.

Larry Linson
Microsoft Access MVP

 

[dewayne]

Anyone know why this is happening?

-----Original Message-----
Here's a workaround. Instead of applying a filter (they seem to be a little
quirky in other ways too, to me), create a WHERE clause, apply it to the
base SQL, and set the Form's RecordSource. Have a "Show All" command button
to remove the WHERE, as well.

Larry Linson
Microsoft Access MVP




.

 

[Allen Browne]

Dewayne, I have not seen the issue you describe, but I have found that you
generally get more reliable results by setting the Filter property of the
form rather than using ApplyFilter, e.g.:

Me.Filter = "SomeField = SomeValue"
Me.FilterOn = True

Let us know if that works correctly for you.

 

[dewayne]

The solution is in this
Microsoft Knowledge Base Article - 269380

 

[Allen Browne]

Dewayne, thanks for posting the solution.

The kb article says this is a problem with Access 2000 SR-1. Is this the
version you were using, or were you seeing the problem in later services
releases as well? Thanks.