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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form - Lock Fields from Editing 0
Lock a form 3
Disable and Lock All Feilds wiht a check box 2
Requery tabbed documents 2
Word Lock specific drop downs on a Word Document 0
unbound form is locking up 3
conditional field lock 5
text box - tabbing issue 5

Back
Top