Tab control password

[PARSO]

search and couldnt find anything to tell me how to do this.

i have a tab control with contains 8 tabs. but i only want 1 to be password protected.
i only need a password entry not a username+ password.

so in other words when the "audit" tab is clicked i want a password popup, user enters password and tab contents is shown. (i dont want it to open the audit form on its own i want it opened as the sub-form in the tab control.

Thanks in advance

 

[PARSO]

update:

ok i have it hiding the labels, but when i move off the tab and then back again the labels are still showing, i need it to ask for the password each time the tab is selected

----

Thanks Uncle Gizmo!!

can anybody help me make the contents of the tab visable only when correct password is entered.

ive tryed using - Label6.Visible = True but im not sure if im using it in right place or if its correct anyway, can anybody help me on where and what to put the code??

thanxs in advance

 

[PARSO]

brill!!

thanks Gizmo

 

[PARSO]

how do i change the code to make it so a whole subform is hidden, rather than just a label? the subform is called "Audit".
when i change the component name to "audit" i get an error saying you cannot hide a control that has the focus"....how do i get around this?

 

[PARSO]

yes, kinda like the attached

 

[PARSO]

ok i htink i kinda understand, could you demo it on the above example pls?
use Label6 as the invisable control..
Thanks

 

[PARSO]

ok, does the new control have to be outside of the subform? and outside of the tab control box?

im guessin its 'TabCtl0.Pages.Item(0).SetFocus' that i edit?

but im unsure of what to...
ive seen Me.Text21.SetFocus about the forums
but it doesnt seem to work when i replace with the above.

 

[PARSO]

sorted!!

thanks Gzmo,
i needed to set the new control as the 1st item in Tab list.