Combo box issues

[joseph.lyons.754]

Hey guys

im populating a combo box from my database i was just wondering how do i prevent the combo box from displaying different instances of the same value. e.g three B&Bs all from ennis. ennis is in the combobox but its displayed three times.

how do i stop this ??

Thanks

[pritaeas]

Show the query you use to retrieve the values (and some sample data would be helpful too).

[simplypixie]

I agree with @pritaeas but off the top of my head, use DISTINCT in your query to only retrieve one instance of the same value.

[joseph.lyons.754]

Thanks Guys Distinct srted it

[szabizs]

You can use distinct or Group BY, either of that works.