Why not use the recordset as an array...

I.e. disconnect the recordset from the database

Then you have all the added functionality of a recordset

like eof,bof,movenext,movelast,movefirst etc