Combo Box Help

  • Thread starter Thread starter Amy Johnson
  • Start date Start date
A

Amy Johnson

I have a combo box in a form. The selections for the
combo box are from a table that lists the supervisors for
a department. How can I get the list to be in
alphabetical order in the combo box? I have tried
alphabetizing the table but that hasn't worked. I did
this by right clicking on the column and clicking sort
ascending.


Any Ideas?
 
Create a query based on the table. Include the fields you want in the
combobox's Row Source. Set the sort order on the desired fields. Use the
query as the Row Source instead of the table.
 
Back
Top