Sorted combo box

[topgeek]

I have two combo boxes. One displays UK towns and the other UK counties. The look-ups are from a single text field tables. The towns drop-down displays the towns in alphabetical order, but the counties drop-down appears o be random in order. I have set the columns to A-Z sorting in the tables and when I open the tables they both appear in alphabetical order. Any idea where I'm going wrong?

Best Regards

 

[Remou]

Hi
Have you checked out the row source of your combobox? It may be set to a query. If so, you could set the sort on the query. I think this happens if the table is merely sorted, rather than indexed on the field you wish to sort by.

 

[ZmrAbdulla]

Click the build(...) button next to the Rowsource of the combobox in the property box. You will be presented a query in the design view set sort ascending in the countries field. Remove if there is any other sorting

________________________________________
Zameer Abdulla
Visit Me
The best thing to spend on your child is your time.