Column Sort Within Combo Box

[grendal]

I have a customer database with a combo box to help search on customer name. For some reason the data in the combo box has a primary sort on my account number column. However, if I look at my customer database within the table format, its sorted by customer name. Has anyone any thoughts? Cheers s-)
Does the body rule the mind or does the mind rule the body - I dunno!

 

[KornGeek]

Create a query sorted on the appropriate column, and base the combo box on the query instead of the table. Sleep is for people with no caffeine.

 

[grendal]

Works a treat - thanks Cheers s-)
Does the body rule the mind or does the mind rule the body - I dunno!