New Record Button

[stevemccauley]

What code do I have to enter to have a button on my form, when pressed, move to a new record?

 

[Hayley Baxter]

Steve

You could use this code

Private Sub CmdAddNewRec_Click()
On Error GoTo Err_CmdAddNewRec_Click


DoCmd.GoToRecord , , acNewRec

Exit_CmdAddNewRec_Click:
Exit Sub

Err_CmdAddNewRec_Click:
MsgBox Err.Description
Resume Exit_CmdAddNewRec_Click

End Sub

If you just put a cmd button on your form by using the wizard access will generate the above code anyway.

HTH
Hay

 

[ddmcn]

Event code for New Record

I concur with Hayley's suggestion...

the code there is what Access puts into the OnClick event when you build the button using the wizard.

 

[stevemccauley]

Thanks, I didn't think of using the wizard