Join 2 Record set in Access and VBA

[Ravi Meghani]

Hi I am very new in Access and VBA,
I have 2 database Detail and Combined
In Detail database, 2 record set and each record set has 3 fields but recordId is common in both the recordset, So i want to import both the recordset into Combined databse and create a new recordset name combined with all the 5 fields. And i want to do this excercise through VBA.
This will be veryheplful for me.
Thanks in advance.

[zmbd]

Ravi Meghani

This sounds a lot like a home work question.

Even in VBA, you would use an append/insert query to accomplish this task.

Please understand, Bytes is not a Code/Homework service. Normally, we ask that you provide your work for us to review. If you will do so now, with a specfic question describing where you are having issues we can provide better help.