I am clearing a field when i am going from one sheet to another. For that i have used action in the other sheet as Clear Field(Field Name). Now if i go back to the first sheet. i want to restore my selection whatever i have cleared. Is there any way to do that ?
What you can do is, when you are nevigating from 1st sheet to 2nd sheet, before clearing the selection make a bookmark of those selection and then clear all selection. Now when you will come back to 1st sheet apply the bookmark you had create.
Hope this will help
Regards,
Kaushik Solanki
Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
That is working but i have a field called Geo level where Region, District and territories are listed. I have another list box which has all the territory Id . Now the problem is i am clearing territory Id when i am moving fron one sheet to other. i have created bookmark. Now i am coming to the other sheet again then Geo Level is at Territory level but the territory Id is cleared.
i have created bookmarks and it is working fine. But the problem is everytime i make changes in selection and move to other sheet a different bookmark is getting created. But in sheet properties i have mentioned a specific bookmark Id(BM01) that gets activated on coming back to the sheet. So if i am selecting something different and go to other sheet and again come back to the first sheet the BookMark(BM01) gets activated and it shows me my first selections not the current ones.
Isn't there a way so that the newest bookmark gets activated on switching between the sheets.
