Is it possible to enter code between "DoCmd.RunCommand acCmdCopy" and "DoCmd.RunCommand acCmdPaste" other than another "docmd" statement
When I do this I get an error message "run command action was cancelled"
My understanding is that the copy command writes to the clipboard so the data should still be there after other code is processed
I am trying to copy the data in an existing record to a new record where the data in each is very similar.
Is it better to use a recordset and loop through the fields, copying the original field data and writing to the new field.
When I do this I get an error message "run command action was cancelled"
My understanding is that the copy command writes to the clipboard so the data should still be there after other code is processed
I am trying to copy the data in an existing record to a new record where the data in each is very similar.
Is it better to use a recordset and loop through the fields, copying the original field data and writing to the new field.