docmd.apply filter problems

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

Paul M

I have been using docmd.apply filter for many years.

I am now upgrading from Office 2000 to 2003
This action no longer works. This filter is limited to one
use after opening a form.

I found the Knowledge Base article 269380 which tells me
to use

me.filter = ""
me.filteron = false
me.filter = "myfilter"
me.filteron = true

The main problem, other than trying to replace hundreds of
filters, is that this creates an extra screen flash.

The old docmd.appplyfilter would go directly from one
filter to another. The new command flashes the screen to
no filter then applies the new filter.

Does anyone know another way to to handle this situation

Thanks

Paul M
 
The article applies to Access 2000 SP1. Have you tried upgrading to Access
2000 SP3? Free download from the Downloads section of support.microsoft.com.
(Be sure to apply SP8 for JET 4 as well.)

The only other alternative that comes to mind is to turn off screen repaints
while you apply the filter:
DoCmd.Echo False

Turn it back on in the error recovery part of your procedure.
 
Thanks, the Echo cmd works

I was wrong about the version before. I am upgrading to
Access 2000 SP3 Not 2003.
This has been a problem since SP1

Thanks for your help

Paul
 
Back
Top