Combobox order problem

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

Guest

I have a form with a combo box that looks at values from a table. The combo
box drop down displays the list in the order of the primary key of the table
no the data displayed.
The table called “Contractor†has an autonumber primary key and a field
called Contractor. How do I simply get the dropdown combo box to display in
alphabetical order?

Any assistance to what is probably a stupid question would be much
appreciated!
 
Instead of using the table directly, create a query to use as the rowsource
for the combo and set the order in the query.
 
Back
Top