Add Button then New record

[Mcrawford]

I would like to create a button on my form that will save the current record
and automatically advance to a new blank form to enter a new record. How is
this done?

I'm new to Access 2003 so the more detail the better...

 

[UpRider]

In the ON CLICK event for the button, type

DoCmd.GoToRecord , , acNewRec
Me.txtName.SetFocus 'this will put the cursor at the named location,
if needed

UpRider

 

[Mcrawford]

Thanks so much, that did the trick!

In the ON CLICK event for the button, type

DoCmd.GoToRecord , , acNewRec
Me.txtName.SetFocus 'this will put the cursor at the named location,
if needed

UpRider