Combo Box Help

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?
 
W

Wayne Morgan

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo box help 1
Using Combo Box Selection to Query a Table 3
Programmatically change combo box sorting 4
Add the command "Clear All Filters" to a Command Button in Access 2010? 0
Combo Box Question 2
cant get cbo to stop outputting key# 0
Combo box referencing another 2
sum combo box based on other combo box 2

Top