Set Focus to first field

[Les Coover]

I want to set the focus on a form to the first field on the form (LName).
The name of the form is frmFacultyEval
I have tried using an form OnCurrent event using

Forms!frmFacultyEval!LName.SetFocus

I also tried

Me.LName.SetFocus

Neither worked. I checked all my tab settings they seem correct.

For some reason the form opens at tab position 7 rather than tab position 0
(where I want it to open)

Any help appreciated.

Les

 

[Rick B]

In my experience, all you would need is

Private Sub Form_Current()
LName.SetFocus
End Sub

 

[Douglas J. Steele]

Have you set the form's Tab Order correctly?