Macro for Cut and Paste

[AgentJ]

I am looking for a way to apply a macro, or some code on a button in a form
that would allow for a record a specific record to be cut and pasted from one
table to another. These would be individual records.

 

[Douglas J. Steele]

Rather than use cut and paste, have the macro run two queries: one to append
the record from table 1 to table 2, then one to delete the record from table
1.