How to Create New record programmatically

[ganesh3084]

Hi all !!!!!!!! I need to create a new record using VBA. I have tried using the following code. But it didnt work.



Private Sub btnNew_Click()
DoCmd.GoToRecord , , acNewRec
End Sub


Plz suggest me

[HiTechCoach]

Do you get an error message?

Is the record set updateable?

Is the form set to allow additions?

Have you tried using the command button wizard?

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