Add New Record Error

[lscheer]

Can anyone help me with this code? I want to add a new record to a form, but I'm getting a syntax error with my code. Also, do I need to use the Update method with NewRec?

DoCmd.OpenForm ("CONTACTS", acNormal, , , acDataModeEdit, acWindowNormal, DoCmd.GoToRecord [,,acNewRec])

Thanks!

 

[R. Hicks]

Not sure what you mean by:
"Also, do I need to use the Update method with NewRec"

But to open the form to a new empty record use:

DoCmd.OpenForm "CONTACTS", , , , acFormAdd

HTH
RDH