Append record to new table button

[Jim]

Hi and help,
I'm creating an access db that has two tables. A form
displays each record for the respective table. I need a
button that when clicked will move only the currently
displayed record to the other table and then delete that
record from the source table.
How do I go about this?

Any help would be gratfully recieved.

 

[Allen Browne]

See:
Archive: Move records to another table
at:
http://members.iinet.net.au/~allenbrowne/ser-37.html

The article explains:
- how it is often easier to just mark the record rather than move,
- how to move (copy, then delete),
- how to do that safely (using a transaction).