Access – Moving records…

At a button’s click, I need to be able to move a single Access 2000 record from one table to another. For example: move record from “Active Data” table to “Expired Data” table. Also, this is a simple local DB, nothing fancy.
Thanks in advance!
Jen