Populating combobox with sorted table data

[BobJones]

I have a client table with a field called location. On a reports form that I have, I want to make a combobox for all of the locations, so it could show all the clients from a particular location and also it would reduce the errors due to someone spelling a place name wrong. I could set the source to the location field in the table, but that would show them all in the order they come out and there would be duplicates.

Any help would be cool. Cheers
Bob

 

[BobJones]

Ok Im an idiot... sorted it... For anyone in the future who needs it..

SELECT Distinct Location FROM Client ORDER BY Locaton