combobox data not sorted (1 Viewer)

[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.)

 

[Pat Hartman]

Tables are unordered sets of data. Therefore, the ONLY way to ensure a particular sequence is to use a query with an ORDER BY clause. When you open a table in datasheet view, Access runs a query behind the scenes and uses the table's primary key in its ORDER BY clause. This fools people into thinking that the data is actually stored in some meaningful order.

 

[moose]

thanks for all your help. job done!!!