it should be pre selected in the designer part ( multbox ) also the both should show the action too. If you can tell me in both, much appreciated
You could either manually select them and then lock them, or I have used a button with actions associated with it to make multiple selections accross multiple list boxes.
The syntax for making more than one selection in one list box is a little confusing but is achievable with some trial and error and something I found within the Community pages of this site.
In the search string for the actions, see below for an example:
(None|SLV|"Revenue GBP"|"Yield GBP")
| denotes a separation between selections made in the list box
" are used to encase an item in the list box which contains a space
Note that it performs the required selections but creates a little wierdness in your current selections box.
Is this what you meant?
Consider also using a bookmark for the selection. A bookmark is easy for your report users to understand and the bookmark selection can be applied as an Action if you need it to be automatic.
Thanks for the reply. However that reply doesn't full fill my answer. Let me elabrote my question with example, suppose selection list has three option in drop down menu. 1.Jan 2.Feb 3. Mar. and I want to have preselected Jan & Feb data at the begning. Of course we could have used book mark option but that actually will not work in my case.
Thanks & Regards
This is what i have done in my application. Have written one macro which is being assigned to "postreload" in Document Properties.
As per perormance,this particular macro won't be time consuming also.
set f = ActiveDocument.GetField ("Year_Order")
f.TopSelect "Year_Order" ,1
set f =ActiveDocument.GetField ("Month_Order")
f.TopSelect "Month_Order" ,2 // number 2 means selecting two values
Note: Year_Order n Month_Order are field names
Hope this help.
If u want that when u open the sheet then Month should always be initially selected as Jan,Feb then u can do the following:
Go to Sheet properties>> Triggers >> OnActivateSheet >> AddActions>>Add
Actionelect In field
Then OK and Apply.