Tab order in Form

[Darth21]

I created a trouble log form. For Example: when the user tabs it moves to the next box until it gets to the end of the form until the last box and when the user hits tab again, it goes to the new record, but the tab is starting from the second box instead of the first. How to i fix this issue.



Example: Clerk is the first field, second field is ride location.... the last field is time available. when the user tabs at the end to a new form it starts at ride location instead of clerk first. I went to the tab order and Clerk is set as first field, but it skips that field and goes to ride location.

Does anyone know how to fix this? If so, please let me know.

Thanks, Brian

[amrut]

When in form's design view, right click in blank area and select Tab order. Select the relevant section on left side and drag the first box to the top.You can also change the Tab Index property of a control in Property Sheet>Tab Index.

[Darth21]

I tried that and it did not work. For the first field is Clerks, the second field is Ride Location and the last field is No Longer 10:35. When the users tabs to the end of the form it goes to the next form, what i want it to do, but the starts in the second field, Ride Location and i want it to start on the first field Clerks. I went to the tab or and Clerks is first in the tab order, but its not started at Clerks, it starts at Ride Location. Any suggestions?

Thanks, Brian

[amrut]

The tab index starts from 0 so the your first box should have tab index 0 to be the first control having focus when the form loads.
Add command button to the form for testing purpose and add following code to it's OnClick event.

Dim ctl As Control
For Each ctl In Me.Controls
Debug.Print "Control name : " & ctl.Name & "  Tab Index : " & ctl.TabIndex
Next ctl

View the result in immediate window. Check the tab index of your first box. You have to set it to 0 to start in the first field.

[Missinglinq]

When you move from one Record to another Record, in Access, the cursor remains in the Control it was in on the previous Record. To set Focus to a given Control, on entering a Record, use code like this:

Private Sub Form_Current()
 Me.FirstControlName.SetFocus
End Sub

replacing FirstControlName with the actual name of your Control.

Linq ;0)>