Tab order different when Finding -v- Adding?

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

Guest

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
 
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.
 
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

Add/Subtract columns from tab to tab in same file 3
Tab order stops at last field 6
Tab order different when adding -v- editing? 5
Tabbing between a main form and a subform 1
Two sets of tab orders?? 1
Tabbing order thru form 1
Cursor position upon clicking into masked field 2
Access 2007 Tabbed form with shared recordset 0

Back
Top