I thougt I would test if it is possible to use an expression in a list box, to let the user click in one place to filter by volume. In this case sales amount by salesman, at fixed sales amount ranges.
This way I can avoid using varables in other objects to achieve the same thing. It does work somehow, but behaves a little strange. See enclosed app, listbox "Sales by salesman".
1) If I select "Less than 50000" the selection above is not greyed. It disappears!
2) If I select "Less than 50000" it shows only one salesman, "Elvis Presley", which is correct.
But, if I select year 2009, it still show only one salesman, "Elvis Presley". Because I have limited the data to only 2009 more salesmen should be visible.
Unselect "Elvis Presley", then select "Less than 50000" again and you will see.
Any idea if this is possible to solve this way at all?
I already know this is possible to solve with variables or macros.
Lars
