Hopefully this will help you
What you could do is write SQL statments to do this....
in the general declarations:
Option Explicit
Private gdbActiveDatabase as Database
Private gdbInactiveDatabase as Database
Private grstActive as Recordset
Command Button to perform task:
Dim pstrSQLSELECT as String
Dim pstrSQLINSERT as string
Set gdbActiveDatabase = _
OpenDatabase("path name to active database")
Set gdbInactiveDatabase = _
OpenDatabase("path name to inactive database")
pstrSQLSELECT = "SELECT * FROM (name of active table in database)"
Set grstActive = _
FormName.gdbActive.OpenRecordset(pstrSQLSELECT)
(this will select all records in the active table you specified, then it will assign that record set to grstActive)
you'll then want to assign the recordset to variables
and write and INSERT sql statement and execute that, which should put it into the new table!
Hopefully this will help.
Rach