>Is it possible to reference a recordset from within a sql statement?

No. But you can join the new query with the one that creates the recordset and run it in the backend.