I am trying to create the transfer of the current recordset of an open form and subform using a command button on the master form to transfer (or copy) this recordset to each table of the form and subform for archiving. How do I begin this task.

RCAREY