the way i'd do it is just get 1 recordset with all of the fields in it. You can do this by usin a UNION sql statement when you retrieve the records
for example
SELECT field1, Field2, Field3 FROM TABLE A
UNION ALL
SELECT field1, Field2, Field3 FROM TABLE B
The ALL makes it include duplicates so if you're sure there can be no duplicates the ALL is not needed.
For this to work the fields have to be the same data types and in the same order.