Add a new record using VBA

[Leif S]

Hi,

In the open event of a form ("frmDPR") I want to add a new record to the
forms recordset using VBA. I will simulate what happens when a user click the
menu item "Records - New Record". Can anyone help me with a way to code this.

Thank U.

/Leif S.

 

[Douglas J Steele]

Try:

DoCmd.GoToRecord acDataForm, "frmDPR", acNewRec

 

[Leif S]

Thanks, Douglas. Works nicely!

/Leif S.