MS Access: Set the focus on second field in a subform whenever a record is viewed in Access 2003/XP/2000/97

Question:  In Access 2003/XP/2000/97, I have a form and a subform (master/detail relationship). The main form is in the Form Header section while the subform is in the Detail section. The problem is every time I add a new record, the cursor won't go to the second field in the subform.

For example, the subform contains the following fields:

1. LINE_NUM
2. LOAD_DATE
3. LOAD_BY

I want the subform to move the cursor to the second field LOAD_DATE whenever adding a new record.

I used the DoCmd.GoToControl Me.LOAD_DATE on the subform's "On Current" event property but I'm getting an error. Please help.

Answer:  To make sure that the focus is on the second field (ie: LOAD_DATE field) whenever a new record is added...or for that matter, whenever you view a record in the subform, try the following VBA code on the subform's "On Current" event:

LOAD_DATE.SetFocus

For example:

Private Sub Form_Current()

    LOAD_DATE.SetFocus

End Sub