Combo Box, list order

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

Guest

I am using a Combo Box to select and display names from a table. The names in
the table are in alphabetic order and to begin with so was the Combo Box. I
have since added new names to the list, the Table list remains in alphabetic
order but the Combo Box is all over the place. Can anyone suggest a cure for
this. Many Thanks Fritz
 
Open the form in design view.

Right-click the combo, and choose Properties.

On the Data tab, examine the Row Source property.
Make it a query that sorts the records the way you want.
 
Thanks for you response Allen.

The row source is as follows: SELECT Suppliers.SupplierName FROM Suppliers;
and the source type is Table/Query.

Do either of these need to be altered?

Fritz
 
Thanks for you response Allen.

The row source is as follows: SELECT Suppliers.SupplierName FROM
Suppliers; and the source type is Table/Query.

Do either of these need to be altered?

Fritz
Click to expand...

SELECT Suppliers.SupplierName FROM Suppliers ORDER BY
suppliers.Suppliername;
Q
Click to expand...
 
Back
Top