Form closes slowly after sort

  • Thread starter Thread starter hubbiida via AccessMonster.com
  • Start date Start date
H

hubbiida via AccessMonster.com

Why would a form take an extremely long time to close if I have sorted the
data while the form was open? I have several forms that behave this way,
based on both queries and tables. If I don't sort the data while the form is
open, no problem, if I do....they take forever to close, and are slower to
open again?
Any ideas on how to avoid this problem?
 
Why would a form take an extremely long time to close if I have sorted the
data while the form was open? I have several forms that behave this way,
based on both queries and tables. If I don't sort the data while the form is
open, no problem, if I do....they take forever to close, and are slower to
open again?
Any ideas on how to avoid this problem?
Click to expand...

That's odd. Are you trying to save the form in the process? If so, it
will be saving a Query with your specified sort criteria.

Try removing filters and sorting prior to closing the form.

John W. Vinson[MVP]
 
Back
Top