>I want to know if it's possible to perform a select statement
>on a recordset.
I just want to make sure that I understand well.
You already have a recordset containing rows (named rs1). You want to perform a second query (named rs2) in which your datasource will be the first recordset so your sentence should look like: Select * from rs1.
If this is want you mean; no you cannot. You have to requery your original data source with a new query.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com