How to open a Form to a Spific vField?

[djclinton15]

Hi, I have a few fields in a Form & when I open the Form I want the cursor to start in a specific field. i.e. [ArtistsId] on this Form. I used it in another dbs & I thought the code wold be:





Private Sub ArtistID_Click()
On Error GoTo Err_Command55_Click




DoCmd.GoToRecord , , acNewRec
Forms![2015_Music_Entries_frm].ID.SetFocus


Exit_ArtistID_Click:
Exit Sub


Err_ArtistID_Click:
MsgBox Err.Number & ": " & Err.Description




End Sub


Any advise/suggestions will be greatly appreciated! Thanks in advanced.

[Perceptus]

Is this any better?

Private Sub ArtistID_Click()
On Error GoTo Err_Command55_Click
DoCmd.GoToRecord , , acNewRec
Forms![2015_Music_Entries_frm].Form.ID.SetFocus
Exit_ArtistID_Click:
Exit Sub
Err_ArtistID_Click:
MsgBox Err.Number & ": " & Err.Description
End Sub

[djclinton15]

Thanks for responding to my thread.Unfortunately, your suggestion didn't work. My Form's Default View is in Datasheet if that makes any difference?