Moving data to another table

  • Thread starter Thread starter stephanie
  • Start date Start date
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
 
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.
 
Back
Top