Moving data to another table

S

stephanie

I want to be able to move data to new table when a option
button is clicked. Click completed and the data on that
form moves to an archive table.

Steph
 
V

Van T. Dinh

I don't normally move Records to an archive Table. I simply have an extra
Field to indicate whether the Record is active or not. In the usual UI, I
simply use criteria in the Queries to show only "Active" Records. This is
much more efficient than moving Records.

However, if you want to use an archive Table, you can write a Sub to run an
Append Query to add the Record to the archive Table and then a Delete Query
to delete the Record from the current Table. Make sure you use transaction
to prevent the case where Append is unsuccessful but the deletion is
performed.
 

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

Top