Mark,
I had so many other problems yesterday that I kinda forgot about this one which I solved by adding another index to the table which then worked. I did not change my code other than to add the new index to the list. Who knows... after all it is Access
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!