Forum Discussion

demaionewton's avatar
demaionewton
Copper Contributor
Nov 04, 2022

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.
Tom_van_Stiphout's avatar
Tom_van_Stiphout
Steel Contributor
Nov 04, 2022
This might be a case where DoEvents could make a difference.

Resources