Set Focus after New Record

[eramirez]

Hi

This is probably an easy fix, but I have a basic command button on a form to add new record, but after a new record is added, I want the cursor to be a certain field. Thanks for your help.

this is the code behind the button:


Private Sub addnew_Click()
On Error GoTo Err_addnew_Click

DoCmd.GoToRecord , , acNewRec

Exit_addnew_Click:
Exit Sub
Err_addnew_Click:
MsgBox Err.Description
Resume Exit_addnew_Click

End Sub


Enrique

 

[pbaldy]

How about

Me.ControlName.SetFocus

 

[eramirez]

Thanks Paul!

That seemed to work.

so just to be sure, this is how it shoud look?

Private Sub addnew_Click()
On Error GoTo Err_addnew_Click

DoCmd.GoToRecord , , acNewRec
ME.ControlName.SetFocus

Exit_addnew_Click:
Exit Sub
Err_addnew_Click:
MsgBox Err.Description
Resume Exit_addnew_Click

End Sub

 

[pbaldy]

No problem Enrique. Yes, that looks correct to me.