Problems with 2 recordsets in one database.

[qwert231]

Has anybody ever had problems using 2 recordsets at the same time, from the same Access database? I have. So, I've been able to streamline most of my code to have only one open recordset at a time...

But, I am at a point, where I need 2 recordsets open at the same time... 2 different tables, but the same database. Is there anything I should be aware of?

 

[qwert231]

Forget it, gonna try something else... maybe some sort of join.