Enabling a whole Tab

[Ryis]

Hello,

I have a form with 6 tabs, one of which is labeled "HEAD OFFICE USE ONLY".
I have a hidden form which has a sub form with a permission level field(in
datasheet view), what i am trying to do is have this tab stay disabled
unless the PERMISSION LEVEL = a certain value. with in this tab there are
4-5 fields. I have set the enabled to no for my tab control but cannot
figure out the code to enable it..

Any help would be appreciated

Ryan

 

[Mark A. Sam]

Ryis,

It would be something like this. You will need to play with the format.

Place code in the current event of the main form like this:

If [HiddenFormName].Form.[SubformName].Form![PermissionLevel] =
"WhateverValue" then
[TabName].Enabled = True
End If

[TabName] would be the Name property of the tab when you click on it in form
Design View.

Without testing I think that this syntax for addressing the subform is
correct,

[HiddenFormName].Form.[SubformName].Form![PermissionLevel]

If I understand you, there is a hidden subform with a subform in your main
form.

God Bless,

Mark A. Sam