Recordset Clones

[link9]

Good morning --

Let's say I have a recordset, and that recordset it currently filtered by some criteria...

If I clone that recordset while it's filtered, do I get a clone of the entire recordset, or just the "filtered" records???

Basically, I'm trying to put a further filter on the records to come up with percentages of total records that meet criteria, so I need to be able to take the 'sub-filter' back off the recordset, but be left with the original filter, which obviously setting the filter back to 0 won't do because it removes my original filter.

Any other creative ways to take care of the problem?

Thanks
Paul Prewett

 

[link9]

The clone gives the whole thing...

Anyone know an easy way to get a recordset with only the filtered records in it??

thx