MS Access form - cursor doesn't start in first tab

[Participant]

Hi all

I'm developing a database at work. There's a data entry form and one minor gripe that's arisen during the testing phase is that when you create a new record, the cursor doesn't default to the first tabbed field, you have to move the mouse to the field and click inside it in order to begin typing.

Some of these guys are entering data at a hell of a lick and it may seem a small thing, but it's actually affecting their speed.

Grateful for anything you might be able to offer!

 

[Participant]

Thanks for the replies. The tab orders are specified and correct in 'View, Tab orders'. They're tabbing through fine and in the correct order, it's just not putting the cursor at the first field of the record.

Have a look at this picture, relevant row at the very bottom:

This is probably relevant too:

 

[Participant]

Here you go:

I'm trying to make data entry a mouseless operation, but I cannot seem to make it navigate to the first drop-down straight away.

Good idea about the column widths, but this is not the reason as subsequent tabs and the other drop downs have also hidden the ID number, but I am not having an issue with tabbing and entering those values.

 

[Participant]

If you tab right through all the fields and then back to the first - does it then have the cursor displayed and selected properly?

Answer: yes.

Thanks for the effort anyway div0 and marc2003.

Looks like I have some more Googling to do, I looked briefly but couldn't find anything. Thanks for the help.

EDIT - looking at the screen above, the focus is still on the 'New Record' button. It looks like I need to somehow transfer focus to the 'OperatorID' field from the 'New Record' button, presumably using a macro as per what marc2003 says.

This is where my knowledge expires (unless there's a default macro action that can achieve this) so unless there are any VB experts on this forum, I'd better do some hunting around specialist forums.

Thanks.

 

[Participant]

The code on the 'New Record' button was:

Private Sub btnNewRecord_Click()
On Error GoTo Err_btnNewRecord_Click


    DoCmd.GoToRecord , , acNewRec

Exit_btnNewRecord_Click:
    Exit Sub

Err_btnNewRecord_Click:
    MsgBox Err.Description
    Resume Exit_btnNewRecord_Click 
    
End Sub

Changing it to...

Private Sub btnNewRecord_Click()
On Error GoTo Err_btnNewRecord_Click


    DoCmd.GoToRecord , , acNewRec
    [COLOR="Red"]Me.[Entered By].SetFocus[/COLOR]

Exit_btnNewRecord_Click:
    Exit Sub

Err_btnNewRecord_Click:
    MsgBox Err.Description
    Resume Exit_btnNewRecord_Click

    
End Sub

...seems to have solved the problem! After the user clicks new record, the new record shows up with the cursor flashing on 'Entered By' combo box.

Many thanks for your help, superb job!

I'm just beginning to understand what a vast tool Access really is. Huge potential but huge potential for knowledge gaps also.