locking forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I lock a tab on a form to open only when a specific box is checked on
another form?
 
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
 
Back
Top