Password protect a page on a tab control

[Leesha]

Hi,

I have [pageAR] that is a page on a tab control on a form. I would like to passoword protect this page so that when someone clicks on the tab they are prompted to enter a password. If they don't know the password they won't be able to see the page. I tried the on click event to have a page the the password load but that doesn't work. What am I doing wrong, or is there a better approach?

Thanks,
Leesha

[HansV]

You should use the On Change event of the tab control instead of the On Click event.

But there is a problem with this approach: Access will first switch to the tab page, then run the code. So you should also hide all controls on the tab page, and only make them visible when the correct password has been entered.

Alternatively, you could hide the tab page, and provide a command button that prompts for the password, and makes the tab page visible when the correct password has been entered.

[Leesha]

I went with option 1. Worked like a charm!
Thanks,
Leesha