Sort Data in a combo box

[Rats]

I have a combo box based on a table. The table is sorted by the Customer surname field using the Order By property. My Problem is the combo box will still display data in the unsorted order ie in Primary Key order.

Any suggestions on how I can make the Combo Box display dat in ascending order of Customer.

 

[krunalprajapati]

write query with order by clause in the row source property of combo box

 

[DALeffler]

Instead of choosing a table from the drop down list in the Row Source property for the combo box in form design view, open the query builder for the combobox by clicking on (...), show your table, pick your table fields, sort according to your requirements.

hth,

 

[Rats]

Thankyou

That did the trick. Thanks for the input.