Order that items are displayed in a combo box.

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

Guest

I have a combo box, based off my main table, that finds records in a form. I want the names to show up alphabetically in the combo box, but I can't seem to figure out where I can set an "order by" property for a combo box. I was familiar with the process in Access 97, but now I am using Access 2000, and I've got the order by set in the form, but not the combo box.
 
Create a query that sorts the records in the desired order, and use that
query as the Row Source for the combo box.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Blondie said:
I have a combo box, based off my main table, that finds records in a form.
Click to expand...
I want the names to show up alphabetically in the combo box, but I can't
seem to figure out where I can set an "order by" property for a combo box. I
was familiar with the process in Access 97, but now I am using Access 2000,
and I've got the order by set in the form, but not the combo box.
 
Back
Top