Form closes slowly after sort

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

 

[John Vinson]

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?

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]