Hey guys,

Does anyone know of a way to close all the open ADO recordsets without having to refer to them individually by name?

For example, I have about 20 recordset objects which I currently close like this:

rs1.close
rs2.close
rs3.close

...etc.

I'd like to be able to just run a loop which would automatically close all open recordsets, just like you can close all open forms with a forms collection, for example. Is it possible?