Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Tab order different when Finding -v- Adding?

6 views
Skip to first unread message

CW

unread,
Oct 2, 2006, 10:33:02 AM10/2/06
to
I would like to set the tab order within a form differently for when adding a
new record, as opposed to when searching for/editing an existing record.
Is it possible to do this, or can there be only one tab order on a form
regardless of mode of use?
Thanks
CW

Brendan Reynolds

unread,
Oct 4, 2006, 4:17:43 PM10/4/06
to
Private Sub cmdTest_Click()

If Me.txtOne.TabIndex = 0 Then
Me.txtThree.TabIndex = 0
Me.txtTwo.TabIndex = 1
Me.txtOne.TabIndex = 2
Me.txtThree.SetFocus
Else
Me.txtOne.TabIndex = 0
Me.txtTwo.TabIndex = 1
Me.txtThree.TabIndex = 2
Me.txtOne.SetFocus
End If
Me.cmdTest.TabIndex = 3

End Sub

In this example txtOne, txtTwo and txtThree are text boxes, cmdTest is a
command button.

--
Brendan Reynolds
Access MVP


"CW" <C...@discussions.microsoft.com> wrote in message
news:8C755A49-4EE4-47B6...@microsoft.com...

0 new messages