View Full Version : Select Distinct


L'apprentis
09-13-2005, 09:42 AM
Hello,
I have a strange problem: one of my comboboxe is looking up a column in one of my table. Some of the record can be duplicated so I decided to change SELECT to SELECT DISTINCT in my SQL for the row source but it doesn't seem to change anything. Is anybody's got an idea why?

lcross
09-14-2005, 02:19 AM
go to the design view and your combo works like a normal query.try there to see if you can work it out. if you like try to send a db for us to see .