secured tabbed page on a form with password box

[dkerley]

i have created a database with a form that has 5 tabbed pages that interlinks
information about a client in a doctor's office. I would like for everyone
in the office to have access to all of the form and 4 of the tabbed pages. I
would like to secure one tabbed page in the form to be password protected. I
created a table for a password. I created a control button to open a form
window and ask you to enter a password. Problem: I need it to only allow
access to the tabbed page if the password is correct.. I'm lost. I want the
secured page in the only form that the staff is going to use to have one page
or section in the form to be secured to who can see tht data. Con this be
done?

example below
client info form: tab 1 page is telephone info/ tab 2 page family
history/ tab page 3/ secured page/ I want to open tab page with a
password protected page. If password is correct then you can see the
information on the tab page 2.

Hope you can help.

 

[Linq Adams via AccessMonster.com]

Here's a very basic hack, with a "hard-wired" password, where Page Three is
the secured page:

Private Sub TabControlName_Change()
If TabControlName = 2 Then
PWord = InputBox("Please Enter Password")
If PWord <> "PageThreePassword" Then
Me.TabControlName = 1
MsgBox "Access to Page 3 Denied!"
End If
End If
End Sub