Control Tab Problem

[mike1975]

I have a Control Tab on a form that has three pages on it. On my first page I have a check box that is called finance, I also have a corresponding page on the tab control called Finance. Basically I want to make the finance page become enabled or disabled depending on whether or not the finance check box has been checked.

Any help would be greatly appreciated.

MIKE

 

[binky]

Try this and see if it will work for you.

Private Sub Finance_Click()  ' this is the check box

If Finance.Value = True Then ' if checked then
    Me.Page3.Enabled = True  ' enable the tab
    Me.Page3.Visible = True  ' make the tab visible
Else                         ' if not checked then
    Me.Page3.Enabled = False ' disable the tab
    Me.Page3.Visible = False ' make it invisible
End If

End Sub

I have both enabled and made the tab visible upon clicking the check box. It isn't the tab itself the gets disabled but the objects within it. (textboxes, labels, etc.)

HTH

Ken :

 

[cdidion]

The tabs are actually in the tab controls pages collection. You can set the visible property of a page in the collection when the value of the checkbox changes:

Private Sub chkBox_Click()
tabControl.Pages(2).Visible = chkBox.Value
End Sub

I think you can reference the page by its name, but I'm not sure:
tabControl.Pages("Finance&quot.Visible = chkBox.Value

Anyway, hope this helps.
-Chris Didion
Matrix Automation, MCP

 

[mike1975]

Thanks for the tips guys - I have it working now! Stand by for more questions no doubt!!!

 

[mike1975]

Hang on - I spoke too soon!! I need the page to remain deactivated for each record! At the moment when I check the box it activates all the records regardless of whether the check box is checked on that record or not!

MIKE

 

[binky]

I'm not sure which event triggers as you scroll through a recordset, it might be After_Update...anyways, find out the event that fires when the value changes as you scroll through your recordset and call your existing code from there.

HTH
Ken