filtering dynamically populated menus to remove duplicates
Thanks Jason, as I was typing my question that was beginning to dawn on me! As I said, I am a complete novice, so I'm only just learning how recordsets work. I didn't even realise you could have more than one on a page.
I must say that the code in that page was pretty much what the wizard produced, so it can be misleading for beginners. Maybe there needs to be more prompting as you go through the wizard. It would be good to have the DISTINCT option available through the wizard too. Just a suggestion from a beginner's point of view.