The Error is: "Update or CancelUpdate without AddNew or Edit".
I have simple code attached to a textbox AfterUpdate Event. The code assigns a value to the textbox. The code runs as expected without any problem.
However (there's always a However) I also have code to duplicate a record using a series of DoCmd.RunCommand statements. This code has been running fine for a few years until I added the textbox AfterUpdate subroutine. The last statement is DoCmd.RunCommand acCmdPaste. After acPaste, Access cycles through all of the code attached to different controls in the form. When it gets to the textbox AfterUpdate code, I get the error. Statements assigning values to variables in the subroutine run. The statement assigning a variable to the textbox on the form gives the error, but only during the Duplicate Record sequence. I can provide the simple code if anyone is interested.
In General, it would be interesting to know the sequence of events that Access executes "behind the scenes" in different events. I was not able to find this on Google. Thanks,