combo box sort order 2

[rproactive]

Hi -

Can't quite get a combo box drop down liast to sort in the order I want. Help appreciated a bunch.

I have a combo box on a form whose row source is a table L_RR bound to column 1. The combo box has the follwong format properties
Column Count 3
Column Widths 0"; 1"; 0"

The table L_RR has 3 columns RR_ID (key) RRName, and RRAbbrev. The drop down list always sorts on the 1st column the primary key. I would like to sort the list on the second clumn (RRName). How can I do this??

 

[RoyVidar]

You will need to do it in the rowsource of the query. In the rowsource property, use the button with three dots at the right, when you enter the query designer, chose the sort order you like, then close and say yes to save the changes.

Roy-Vidar

 

[ZmrAbdulla]

Go to the Design/SQL View of the Rowsource and set sorting accordingly.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[rproactive]

thank you both
and many ***