I have a sheet that displays data in a table box only for a specific value in a field. This is accomplished by placing a 'Select in Field' Action for the OnActivateSheet event. Works great! However, it will undo selections for other fields in the application in order to fullfill the action. I want to be able to go back and have those values re-selected OnLeaveSheet. Kind of a 'restore state to previous conditions' action.
I have been attempting to use bookmarks by creating one as I go into the tab and then applying that bookmark on leaving the tab. Has anyone used this technique successfully? Other ways?
Without the Lock Field, Clear would blow up the table box.
But the field doesn't unlock when I leave the sheet. The bookmark step will only work if the bookmark exists. If I make a new one each time, well,.....
Does someone have a simple example of how this might work?
Background: the system we use has a field in a table that does double duty. It allows the id of the user OR the name of a group. The userid is used to identify users in the system and in my application. And my section access is based on it. So the users of the system don't have access to the 'users' with the name of a group. I just want to display the objects in the system with the group name. I've tried a number of things, including adding the group name as a 'user' and adding it to the section access. Nothing so far. I seem to be right around the edges of a solution, but nothing that's ready for prime time.
