Form displays #DELETE before closing

  • Thread starter Thread starter Empque
  • Start date Start date
E

Empque

I have a form used to make changes to a table containing records appended
temporarily for editing by the user. When finished, the user clicks a
"submit" button. This triggers queries which moves the updated records back
into the production table, and clears the temp table of the records (user is
done with them). In spite of turning off the echo first, and closing the form
before turning the echo back on, the controls on the form display #DELETE for
a couple of seconds before the form closes. How do I prevent this?
 
Empque said:
I have a form used to make changes to a table containing records appended
temporarily for editing by the user. When finished, the user clicks a
"submit" button. This triggers queries which moves the updated records
back
into the production table, and clears the temp table of the records (user
is
done with them). In spite of turning off the echo first, and closing the
form
before turning the echo back on, the controls on the form display #DELETE
for
a couple of seconds before the form closes. How do I prevent this?
Click to expand...


Just an idea: how about hiding the form before starting the process?

Me.Visible = False

' ... clear temp table ...

DoCmd.Close acForm, Me.Name, acSaveNo
 
Back
Top