How do you Sort A list box on a form from a Combo Box?

[Guest_imported]

Is this even possible...I've tried everything that I know which isn't much but nothing seems to work..can someone help out please?

 

[PaulF]

yes, it's possible, by either changing the listbox's rowsource then doing a requery on the listbox, or if it the listbox rowsource is based on the combo box, then doing a requery on the listbox should do the trick. Sometimes a refresh of the form is required to display the current results. If this doesn't solve the problem, then a better explanation of exactly what the sort criteria is based on, and the contents of the listbox might make it easiser to resolve this problem


PaulF

 

[elizabeth]

... and paste the combo's underlying SQL stmt (row source property) here.

 

[VKTiger]

If your combo box is based on a table or a query, go to the RowSource of the combo box, click on the build (...) button and select your sort order.