A Better way to Save & Proceed to New Entry Form?

[nick404]

I am looking for a better, surefire, way to save entered data and then proceed to new clean record for the user to enter new data into. Currently the coding behind my button is

Private Sub bttnSaveEntry_Click()
DoCmd.Save
DoCmd.GoToRecord , , acNewRec
End Sub

I realize the Save command is redundant in the case of go to a new record, however I added it in there as a safeguard since occasionally when the user clicks the button it will be presented with an error message "error "###" cannot proceed to designated record" or something similar. I used to have " , , acNext" but kept getting that message to switched it to NewRec. I haven't been able to figure out a better way to execute saving the record and proceeding to a clean form for entry. I have some fields set as required so I can't just set everything to null, plus it needs to save the data first. Thanks for help

[ItsMe]

IIRC Docmd.save is not saving any data and will throw an exception if used in an accde or on a machine that only has Runtime installed.

I use

If Me.Dirty then
Me.dirty = false
end if

[June7]

Right, the correct method would be:

DoCmd.RunCommand acCmdSaveRecord

OR the method shown by ItsMe.

[Missinglinq]

As ItsMe suggested, your attempt to save the Record

DoCmd.Save

doesn't save the data in a Record! It saves Design Changes made to the current object, when no object is specified; in this case it would be the Form itself.

If you're receiving an error saying that you cannot go to the designated Record, you need to figure out the real reason why, because whether or not the Current Record has been saved has no bearing on moving to a New Record via the OnClick event of a Command Button.

Linq ;0)>