DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.GoToRecord , , acNewRec
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdPaste
I use the code above to effectivly copy and paste the information from a record to a newly created one. This happens on a fairly regular basis at different times depending on the user input on multiple fields. I occasionally get an error saying that the command paste is not avalable. I can't understand why it is happening and have no luck trying to reproduce it however it causes a big issue when it does happen so any advice would be appreciated.
Regards
Adrian
DoCmd.RunCommand acCmdCopy
DoCmd.GoToRecord , , acNewRec
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdPaste
I use the code above to effectivly copy and paste the information from a record to a newly created one. This happens on a fairly regular basis at different times depending on the user input on multiple fields. I occasionally get an error saying that the command paste is not avalable. I can't understand why it is happening and have no luck trying to reproduce it however it causes a big issue when it does happen so any advice would be appreciated.
Regards
Adrian
