Query a recordset?

I've opened a recordset in VB 6.0, using ADO - I set the source property of
my recordset equal to an SQL statement - datasource is an Access DB. How
can I use that record set as the datasource of another recordset. Or, how
can I query against that open recordset?
Thanks,jim