can the tab order be changed based on

[Guest]

option buttons? for instance, if OB1 is selected, all textboxes are included in the tab order. If OB2 is selected, textbox1 & textbox4 are removed from the tab order.

Thanks for the help

 

[dk]

Yeah sure - you can change the TabStop property of your textboxes at run-time e.g.

Private Sub OB2_Click()
If OB1.Value = True Then
Me.TextBox1.TabStop = False
Me.TextBox4.TabStop = False
Else
Me.TextBox1.TabStop = True
Me.TextBox4.TabStop = True
End If
End Sub

Private Sub OB1_Click()
If OB2.Value = True Then
Me.TextBox1.TabStop = True
Me.TextBox4.TabStop = True
Else
Me.TextBox1.TabStop = False
Me.TextBox4.TabStop = False
End If

End Sub

HTH,
D