Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Back
Top