I've come across using disconnected recordsets before in a VBA book I skimmed through and they seem like they should be really useful, unfortunately I've never come a situation where they would actually be useful :s

Plus I don't know of a way of filling them without looping (or memory leaks) which has always put me off.

Maybe this is their calling - lots of filtering and finding on a dataset! They do look as though they would be much faster than filtering in Excel