Disabling a subform on tab control through a checkbox

[Leah]

Hi there,

I have looked everywhere but cannot seem to find an answer to this, my apologies if it has been posted anywhere else.

I have a database called 'Employees' with which I have the main form 'employees' on the first page and then have three tabs with several subforms on them.

I have several check boxes on the Employees form which I wish to grey out the subforms if they are set to No.

Is this possible?

Cheers,

Leah

 

[Rich]

Form_Current
If Me.MyCheckBox = True Then
Me.SubformControlName.Enabled = False
Else
Me.SubformControlName.Enabled = True
End If


MyCheckBox_AfterUpdate
Form_Current
End Sub

 

[Leah]

Thanks so much Rich.. and so fast! I'll try it at work tomorrow...

Cheers,

Leah