Filter Problems with SP3

  • Thread starter Thread starter Paul
  • Start date Start date
P

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




.
Click to expand...
 
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, 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.
 
Back
Top