Of course I'm not... you need a recordset if you want to get data from the database.

In the code posted the recordset is opened, not read (only added to), and then closed.

By definition, the same recordset cannot be used anywhere else - so it is pointless to use it in this case.