Clear form after append query

  • Thread starter Thread starter Red via AccessMonster.com
  • Start date Start date
R

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top