Clear form after append query

[Red via AccessMonster.com]

Good day all,

I have a question and I'm sure there is a way to do this but can't find any
examples on how. What I have is a form controlled by a table tblwaitinglist.
I have a an append query that appends the records to a tblinitialdata. What
I would like to do id once the append query runs, the record is deleted from
the tblwaitinglist. So after I hit the append button, the query runs record
appends and the form clears. I hope this makes sense and any help would be
greatly appreciated.

VR,

Red

 

[Allen Browne]

You say that you execute an Append query to add the records to
tblInitialData. In the same code, execute a Delete query to remove the
record from tblWaitingList.

The safest way to do this is to wrap both queries in a transaction, so you
get an all-or-nothing result. Details in:
Archive: Move records to another table
at:
http://allenbrowne.com/ser-37.html