remove the filter

[Dan]

I have a form that takes a long time to open and I think
that the problem is that I have to remove the filter when
the form is opened. It also has a subform that contains a
couple hundred records that seems to slow it down a
little bit but it goes a lot faster if the remove filter
command is not there. This is the command that I am using:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 3, 0,
acMenuVer70

I have tried to have the other forms remove the filter
when they are closed but it doesn't help. Is there a
better way to do this other than having to remove the
filter when the form is opened?

 

[Allen Browne]

Dan, unless you are explicitly turning the filter on when the form opens, I
doubt this is the issue.

Take a look at Tony Toews' list in:
Access Performance FAQ
at:
http://www.granite.ab.ca/access/performancefaq.htm

It is much more likely to be some of those issues, such as Name AutoCorrect,
subdatasheets, and so on.

If you have code running the the Open, Load, or Current events of the main
form or subforms, you could try commenting that out as well.