Clearing a Form to Reset for New Record

[manderson]

I have a form that opens blank using a macro to add a new record. I added a command button that saves the record. Can anyone help me with code I can add to the command button's "Save" event procedure that will clear the fields and reset the form in order to enter another new record? Thanks for any response in advance.

 

[pbaldy]

Look at

DoCmd.GoToRecord

 

[khawar]

Insert this code after the code you are using for saving your record

DoCmd.GoToRecord , , acNewRec

 

[manderson]

Perfect! Thank you both very much!

 

[missinglinq]

Actually, DoCmd.GoToRecord , , acNewRec will both save the current record and go to a new record, all by itself!