Sorting Data in a DATA BOUND Combo box

Hi!

I just want to ask how can I sort the content of a DATABOUND Combo box (i.e. Alphabetically). Since the index of the combo box is the code link to the base table which is sorted ASCENDING BY CODE what should I do to sort the DESCRIPTION that populate in a DBCOMBO box control.

Thanks in Advance.

Brandon
bmarananAsked:
Who is Participating?
 
watyConnect With a Mentor Commented:
You have to do your select as following

Select YouCode, YouDescription from YourTable Ascending by YouDescription

Youd Combo will be sorted by the description. The related code doesn't need to be sorted.


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.