Running append then delete with one click?

[JohnC]

I'm not sure if this is possible but I hope so! I have an append query which
is run by a button on a form. This query moves "Confimed Records" to another
table. Is there any way I could delete the same records from the old table
without the user clicking another button to run a delete query? I know this a
form question so I have posted it twice. Please help?

 

[Allen Browne]

See:
Archive: Move records to another table
at:
http://members.iinet.net.au/~allenbrowne/ser-37.html

The article explains when and how to do this, and how to wrap the 2 action
queries in a transacton so the Delete does not occur unless the Copy
succeeds and vice versa.

 

[JohnC]

Thankyou very much my friend.