Error trapping

[jesseb]

I get an error on a form that is perplexing ot me. When the form is first opened and a person inputs and then clicks a "save" button I have placed the error # 29068 occurs. The code behind the button is:

DoCmd.save acForm, Me.name
DoCmd.GoToRecord , , acNewRec

It asks to end or debug. If you select end then click save the button works without an error. Why and what can I do?

Thanks

 

[Jonathan Kok]

Try using this code (instead of Docmd.Save...):

DoCmd.RunCommand acCmdSaveRecord