setfocus on newrecord or nextrecord

[superrob5]

when I click on the ado control on the form I want to be able to set the focus to the first field. I know how to use setfocus but I dont know where to put the code.?????




Thanks in advance.

 

[Nouba]

you could ask in the form's current event if the pointer is in a new record

Private Sub Form_Current()
  If Me.NewRecord Then
    Me!YourControl.SetFocus
  End If
End Sub

 

[superrob5]

thank you