filtering dynamically populated menus to remove duplicates
Thanks for your offer of help. I have attached the search file. Is that all you need?
I did try using SELECT DISTINCT, which only seemed to work when I had one column in the recordset, although I Googled it and, from my limited understanding, it should have worked. As soon as I put the other columns in it stopped working.
Just to give a bit more info: my database has a list of publications that are classified into different study types, for example. Many of them fall into the same study type, but I want the user to be able to select from a list of the study types, not every single entry in the column which has many multiples of the same one.
I don't know if this makes it more complicated, but there are more menus on the page that need filtering in the same way.
Thanks for any help you can give. I'm sure its a common problem, but as a beginner at this a bit of guidance would be wonderful.