Save and new record

migrif

Registered User.
Local time
Today, 14:33
Joined
Jul 14, 2008
Messages
15
I am looking to add a save button to a form, and following the save, open the form in a new record.
Thanks in advance
 
You can probably accomplish both with

DoCmd.GoToRecord , , acNewRec
 
Actually, all you need to do is to move to a new record; when you do this Access will automatically save the current record!
Code:
Private Sub SaveAndNewRecord_Click()
  DoCmd.GoToRecord , , acNewRec
End Sub
 
Thanks for the assistance, I feel pretty dumb now, as I knew that going to a new record saved the previous record. Thanks again!!
 

Users who are viewing this thread

Back
Top Bottom