Is there any way to get an accumulative YTD or MTD listbox?

[marcel_olmo]

Hey guys, I'm just wondering if this is possible, and if that is possible avoiding macro stuff.

My idea is, for example, if I click in a month (p.example September), get all the months from January to September selected.

Something like this :

Any help would be appreciated.

Cheers!

[#2]

Hello Marcel,

I would use a trigger. There are different triggers and possible events when the trigger is fired. Fired means that one or more actions are executed. I your case you would define a trigger with a selection action. See settings --> doc properties --> triggers. Unfortunately there is no trigger event when using a listbox. My favorite for your purpose would be a button with a selection action as trigger. Alternative you can use a field event trigger but this needs a little experience with triggers. Don't hesitate to ask for specials when using them.

HtH

Roland

[marcel_olmo]

Thanks Roland, It seems to be hard stuff. Maybe in QV 10 you can attach a variable or an action inside a listbox, because this is my desirable behaviour.

By now, maybe I'm gonna ask to my customers to select always all the accumulative months manually. 😄

Thanks anyways colleague!

Marcel.

[bismart]

I would create an inline table as follows

M1 Month

Jan , Jan

Feb, Jan

Feb, Feb

Mar, Jan

Mar, Feb

Mar, Mar

etc...

Then use M1 in listbox for user to select and corresponding Month value will link to Month on your transaction file