Form displays #DELETE before closing

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

 

[Dirk Goldgar]

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?

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

Me.Visible = False

' ... clear temp table ...

DoCmd.Close acForm, Me.Name, acSaveNo

 

[Clifford Bass]

Hi,

Or maybe a Me.Requery immediately after you do the delete?

Clifford Bass