skipping tab index

[emidkiff]

I have a rather large form with about 60 or so text
boxes. These text boxes are grouped in relation to each
other. I want my user to be able to skip certain groups
of text boxes by selecting a check box or something when
there is nothing for them to enter. I think that would
save them a lot of time. I am having a problem in finding
a way to tell then check box that once it is clicked, to
skip from tab index 13 to 27 or something like that?
Anyone have any ideas on how I could do this?

 

[Allen Browne]

Use the AfterUpdate event procedure of the check box to SetFocus to where
ever you wish to jump to.

This example jumps to a control named SomePlaceElse if the user checks the
box named chk1, but not if they uncheck it:

Private Sub chk1_AfterUpdate()
If Me.chk1.Value Then
Me.SomePlaceElse.SetFocus
End If
End Sub