Combo Box

[Guest]

I have combo box that is based on a table that has an ID field (which is
autonumber) and a Description field. When I drop down the combo box, the
items are showing in ID order. I would like them to be sorted in alphabetic
order of the description.

Is there any way to do this?

 

[Guest]

Hi, Jenn.

Sure. Add an ORDER BY clause to the SQL statement in the combo box' Row
Source property. Something like:

SELECT YourTable.ID, YourTable.Description FROM YourTable ORDER BY
YourTable.Description;

Hope that helps.
Sprinks