Not sure if this is going to help as I didn't have the full details of exactly what you are doing so it's tough to provide sample code. usually if I am working with multiple recordsets I'll do the following:

rst1.open "SELECT tbl1.ID, tbl1.SomeField FROM tbl1;"
with rst1
do wile not .eof
rst2.open "SELECT * from tbl2 WHERE tbl2.ID = " & rst1.fields("tbl1.ID") & ";"
'do some work with for importing, deleting and updating using this or more recordsets
rst2.close
.movenext
loop
end with
rst1.close
set rst1 = nothing
set rst2 = nothing

This way you only go through the first recordset once. Hopefully I'm answering along what you needed to know. Cheers.