list box - sorting of the values

[Anonymous]

Hi

I want to know if anyone knows how to sort the date presented in a list box?

I have three list boxes - and when I click on a value in the middle listbox I can see that all of the years are associated with the selected value (the upper list box), but I can't see which activity names (the list box in the bottom) that are associated with the chosen value - unless I scroll through the many many activity names.

I was wondering if there were some kind of function, that sorted the values in the list boxes, so that the associated values are listed in the top of the list box and the excluded values are represented in the bottom of the list box.

Thanks in advance.

Kind Regards Maria

[Anonymous · Accepted solution]

I found out what the problem was - or my collegue did.

He identified that the sorting didn't work because I have an expression in the field (in stead of a variable name). Without the expression, the sorting worked.

Then he found this discussion:

Listbox Expression sort problem

It says that the expression from the general tab should be copied and inserted as an expression in the sort tab also.

And now the sorting works!