code to add a new record

[Ben]

Hi all

What is the code necessary to add a new record on a form? Specifically, on
the bottom of my form there is a record nevigator, the last button there is
the new record button. What is the code to add a new record that is akin to
pressing the add record button?

Thanks,

Ben


--

 

[Daniel Pineault]

DoCmd.GoToRecord , , acNewRec
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Ben]

Hi Daniel,

That did it, thanks so much.

Ben