How do I prevent the user from changing the selected tab page?

[amitCG]

How do I prevent the user from changing the selected tab page?

Can somedody give me an example code..

Thanks

[coolbiz]

I can think of 3 ways to do it.

* Trapping the event when the tab page changes (can't remember the exact event is). For this to work, you need a global variable that acts as a flag whether to allow user to change the tab or not. You need to test for 2 conditions. First whether the selected tab is the tab that you want to display. If it is, then just exit out from the sub. If it is not, then check if the global variable is set to allow user to change. If it does, then just exit sub. Otherwise, select back the tab that you want user to be restricted to.
* Check if TAB object has ENABLED property. If it does, then you can disable the other tabs except that one that you need to restrict user to. (I can't remember if there property exist or not.)
* Sets the VISIBLE property of other TABS to false. Then they can't change to the others at all.

-Cool Bizs