Okay, here is code that takes data from one table and moves it to another. It also starts by deleting all the data in tblMerge first, to make sure it is clean before it starts.
This only moves the values from one field, but you can add others. Since I do mostly Access/SQL, this is ADO working on local tables. This will also work in Access, or Access/Access, as long as the tables are linked, otherwise you will need a connection object as well.
Don't worry about my table and field names, they are from another post database.
Dim iSelect As Integer
Dim sSQL1 As String
Dim sSQL2 As String
Dim rs1 As ADODB.Recordset
Dim rs2 As ADODB.Recordset
Dim i As Integer
i = 0
iSelect = Me.Text3
sSQL1 = "SELECT TOP " & iSelect & " tblGus2.Num FROM tblGus2 ORDER BY tblGus2.Num"
Set rs1 = New ADODB.Recordset
rs1.Open sSQL1, CurrentProject.Connection, adOpenDynamic, adLockOptimistic
sSQL2 = "SELECT * FROM tblMerge"
Set rs2 = New ADODB.Recordset
rs2.Open sSQL2, CurrentProject.Connection, adOpenDynamic, adLockOptimistic
Do Until i = iSelect
rs2("Num") = rs1("Num")
i = i + 1
Did that help? It does work.