Add Button then New record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
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
 
Thanks so much, that did the trick!

UpRider said:
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
Click to expand...
 
Back
Top