My point was that such data structures exist and can be accessed/used with Access.
Yes I'm with you on that. And thank you again for the link. I found the link I posted about the different data structures and I was struck by the fact that I never seem to have a need to use them.
In other words I was wondering if there is a particular case in MS Access where you would use them.
It's like I am lacking something from my repertoire, but then I don't have anywhere to apply it. That's what got me thinking, I'm probably doing everything I need to do already but in a different way...
The thing is, if I'm going to get proficient in another language, I'm going to need to be comfortable with these different ways of doing things.
It's the same old story, you're much better off learning techniques in the language you are familiar with.
So that should be my next step, next time I think of using a recordset loop, I'm going to try it with a Dictionary and a Class Module... (maybe!)