Forum Discussion

demaionewton's avatar
demaionewton
Copper Contributor
Nov 04, 2022
Solved

Cloning a record works ONLY if I add a MsgBox

I have a very simply VBScript that clones a record taken almost step-by-step from an Access Macro.  Here's the copy: DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdCopy DoCmd.RunCommand ...
2016
access
Access Web Database
  • demaionewton's avatar
    demaionewton
    Nov 04, 2022
    Did a bit of research and found that I don't need the 2 lines:
    DoCmd.RunCommand acCmdRecordsGoToNew
    DoCmd.RunCommand acCmdSelectRecord
    These don't seem to be necessary. Removing them and the MsgBox eliminates the bug.
demaionewton's avatar
demaionewton
Copper Contributor
Nov 04, 2022
Did a bit of research and found that I don't need the 2 lines:
DoCmd.RunCommand acCmdRecordsGoToNew
DoCmd.RunCommand acCmdSelectRecord
These don't seem to be necessary. Removing them and the MsgBox eliminates the bug.

Resources