When a user opens the document all the previous months of the current year should be selected.
I'm able to do so using a bookmark, and select this bookmark by the OnOpen trigger. Problem here is that I have to manually update the bookmark every month.
To make my life easier I'm looking for a solution that does this for me. Perhaps with a variable.
I already tried to use the OnOpen trigger on my year field (easy: year(today)) and month field (='<=' & '$(vPrevMonth)' ) (vPrevMonth returns 30-09-2016 for example)
This does the trick, however, in my month listbox the months are not properly selected (no green selection...) Future months are greyed out. So if the user looks very close he/she would be able to see that there is a 'active selection'. (Also visible in the Current Selection(s) box)
My question: what would be the solution to get a proper selection on opening?