Delay in flosing form when filter applied

S

Steve@hghtest

I have a continious form where I placed buttons ontop of certain fields that
will apply a sort based on those fields. When someone applys a sort and then
later goes to close the form, there is a 15-45 second delay in closing the
form. When no sort is applied it closes normally.

If this means anything, my db uses sql through odbc.

Any ideas?

Steve
 
J

John Webb via AccessMonster.com

Are you closing the form using your own navigation?

If so I would suggest you use the following:

DoCmd.Close acForm, Me.Name, acSaveNo

The important part is the final argument which prevents the changes being
saved to the form itself - the data will still be saved if any
modifications were made.

Hopefully this should speed it up.
 
Top