Select Distinct

[L'apprentis]

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]

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 .