adding a record to a table using cmd button

[charu]

i am finding it difficult to add a record to my access table 'employee' using a command button which i pasted on my form 'employee'. i have written the event code
Private Sub Add_Record_Click()
On Error GoTo Err_Add_Record_Click


DoCmd.GoToRecord , , acNewRec

Exit_Add_Record_Click:
Exit Sub

Err_Add_Record_Click:
MsgBox Err.Description
Resume Exit_Add_Record_Click

End Sub. but this is not working or i am unable to add a record to the table. can any one help me to solve this problem.

[NTC]

does form 'employee' have table 'employee' as its record source?

[michaeljohnh]

Wouldnt you want the new record command be executed with the OnLoad event for the form not with the button click? And then the OnClick event contain a save record command?

[charu]

no. how can i connect the form to this table employee?