Copying a record from one table to another

  • Thread starter Thread starter Aran
  • Start date Start date
A

Aran

I want to be able to copy a record from one table and
place that record in another table and deleting it from
the original table in the process in a click of a button,
is this possible?

Basically once I need to archive an item all you would
need is to have the record on screen and select
the "archive" button.

Thankyou in adavnce
 
Aran,

To do this with a macro, you will need to make an Append Query to add
the record from the first table to the second table. Then, you can use
a macro with two actions, firstly an OpenQuery action to run the append,
and then a RunCommand/DeleteRecord action to delete the local record.
 
Back
Top