sorting problem in VB's combo box.

hi all,
I have a recordset contains 2 fields.
here is my code to load the recordset to the combo box:
    cboBoxToLoad.Clear
    objADORecordset.MoveFirst
    Do While Not objADORecordset.EOF
        cboBoxToLoad.AddItem objADORecordset.Fields(0)
        If bIsItemData Then
            cboBoxToLoad.ItemData(cboBoxToLoad.NewIndex) =
objADORecordset.Fields(1)
        End If
        objADORecordset.MoveNext
    Loop

in the database, I am setting the fields(0) desc and asc. but no matter what
i set, the combo box shows up the records asc for the fields(0).

Please help!
chrislee8Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

chrislee8Author Commented:
Edited text of question.
0
DambalajiCommented:
Set the Sorted property of the ComboBox to True. It will Solve Your Problem
0
leg1Commented:
Actually, Dambalaji, it sounds like the problem is that sort is set to true and thus changes in the rst "order by" are not being respected.  Set sort to false and the entries will appear in the same order that they are added.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

chrislee8Author Commented:
I am sorry, Dambalaji, leg1 is right.
leg1, would you answer the question so that i can give you the points.
Dam, again, nothing personal.

Thank you guys so much for your time.

it works well now.

chris :)
0
caraf_gCommented:
chrislee, you can accept leg1's comment as an answer. Look at the "title bar" on leg1's comment.
0
caraf_gCommented:
;-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.