I did try using a recordset and changed variuos properties along the way but if anything it was slower than what I have now.
It just seems to be ignoring the index as far as I can see.

Alec.