1.11M Members

Combo box issues

 
0
 

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

 
0
 

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

 
0
 

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.

 
0
 

Thanks Guys Distinct srted it

 
0
 

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

You
This article has been dead for over six months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: