Alphabetical Listing Not Correct

[dragongunner0351]

Hello all, I have a form that has an unbound combo box that is linked to my customer table. The user begins by typing in a few letters of the company name then the rest is autofilling, pretty routine.
However, the company names in the combo box are not showing up in alphabetical order. At a quick glance it appears to be but as you dig deeper you can realize it is not completely alphbetized.
I have sorted the customer table several times in ascending order but it only seems to make things worst.
If any one can help I would greatly appreciate it.

 

[Remou]

Have you sorted the SQL in the row source of the combo?

 

[SgtJarrow]

Instead of linking directly to the table to get the data, create a query and sort this based on the column you want. Then use this qeury as the source for the combobox...

Accessing the table will result in the sort order being based on PrimaryKey, no matter how you "sort" the table.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[dragongunner0351]

Thank you for the replies I will try your suggestions