locking forms

D

Denise

How can I lock a tab on a form to open only when a specific box is checked on
another form?
 
M

Michel Walsh

Hi,


You can use the On Change TabControl event handler to look at the value
of the tab control (the new tab to be displayed) and proceed from that
point, such as

Private Sub TabCtl0_Change()
If Me.TabCtl0.Value = 2 Then Me.TabCtl0.Value = 1
End Sub

will refuse to display the third tab (value=2), and would rather redirect it
to the second tab (value=1); tab controls value start at 0


Hoping it may help,
Vanderghast, Access MVP
 
Top