How to write VBA code in AddNew Button In Access DBA

[ganesh3084]

Hi All

Could you please help me the way to writing VBA code in Addnew Button in Access 2003.

[HiTechCoach]

I would use the command button wizard. Select record operations then add record.

Example code:



Private Sub Command23_Click()
On Error GoTo Err_Command23_Click


DoCmd.GoToRecord , , acNewRec

Exit_Command23_Click:
Exit Sub

Err_Command23_Click:
MsgBox Err.Description
Resume Exit_Command23_Click

End Sub