combobox data not sorted

[moose]

on my form i have a combobox which gets its data from customer in tblcustomer. in the table the customer field id sorted alphabetically by customer name but somehow in the combo box it is not sorted. it was this morning but somehow it has lost the sort. can anyone help please

Thanks in advance

 

[ColinEssex]

In the comboBox properties click on RowSource and the little grey square ...
That'll get you to the query grid of the combo, sort the data there

Col

 

[The_Doc_Man]

If the data appears to have lost the sort, I would have to assume that the customer name isn't the primary key. Otherwise, this could NEVER happen.

The sure-fire way to prevent this for a non-primary key field is to build a query that sorts on that field. Then build your combo box from the query, not the table. (Shortens the amount of data you have to consider, too.)

 

[moose]

thanks for all your help. job done!!!