Combo Box, list order

[Fritz]

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

 

[Allen Browne]

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.

 

[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

 

[Bob Quintal]

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

SELECT Suppliers.SupplierName FROM Suppliers ORDER BY
suppliers.Suppliername;

Q