Access permission on tabs.

[Danden]

I have a form with several tabs and I don't want to give permission for some users on some tabs.
How can I do it? Has anybody some ideas, maybe some codes?

 

[Cronk]

You can set the Enabled property for the particular tabs to False

For example
Me.MyTab.Pages(2).Enabled = booPermission

 

[ChrisO]

Attached is an Access97 demo which has been converted to Access2003.

Depending on current user name the Tabs are either shown or removed.
It’s a simulation which allows you to test the code. Normally it would set the Tabs just after login.

There is also a Form for ‘Admin’ to configure who gets to see what.

Chris.