Copying a record from one table to another

[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

 

[Steve Schapel]

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.