Thanks Jamie.

Blazingly simple as usual, though I'd still like to know why the filters
aren't maintained when the RS is passed to the pivot.

Robin Hammond
www.enhanceddatasystems.com


"Jamie Collins" wrote in message
om...
"Robin Hammond" wrote ...

It rather astonishes me that this is the only reliable route I have
found,
but here's a solution to this that very annoyingly creates a new
disconnected recordset and clones every single value across while the
filter
is applied to the original.

I'd still be interested if anyone can think up something better.

Hi Robin,
You can save the filtered recordset to an ADO Stream and open a new
recordset based on stream. Here's some code:

http://www.able-consulting.com/ADO_Faq.htm#Q42

Jamie.

--