Delay in flosing form when filter applied

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top