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