Loading select tabs on a control panel

[Chris v.]

I'm using Access 2007. When my users log in to the application, the
application retrieves their "permission level" (1 - 5) which determines which
tabs (pages) of the control panel they can use. I want to build 1 Control
Panel and only load the user's tabs. based on their permission level. How do
I set the page's visible property to "No" before the control panel loads for
pages they the user should not view? Can I set the visible property of the
Control Panel pages from the On Click event of the Login sForm's Submit
button? If so, can you provide some sample code that I could model?

Thanks.

 

[PieterLinden via AccessMonster.com]

I'm using Access 2007. When my users log in to the application, the
application retrieves their "permission level" (1 - 5) which determines which
tabs (pages) of the control panel they can use. I want to build 1 Control
Panel and only load the user's tabs. based on their permission level. How do
I set the page's visible property to "No" before the control panel loads for
pages they the user should not view? Can I set the visible property of the
Control Panel pages from the On Click event of the Login sForm's Submit
button? If so, can you provide some sample code that I could model?

Thanks.

Do it in the open event of the form. Just set the page's visible property.