I don't use this method, but try removing the parentheses
DoCmd.RunCommand acCmdSaveRecord
I test the form .Dirty property and set to False to save a record if need be
Well, had to test and it appears either way works. By any chance is this code being called from another procedure even though it appears here that it is a button click? If so, the error may be occurring upstream.
Last edited by Micron; 01-13-2019 at 02:04 PM.
Reason: added info
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.