I have a form for style reference with a linked subform with color and labeling choices available for that style.

I used the same docmd statements that comes up with the duplicate record button wizard to start a copy of the record listed below.



DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdRecordsGoToNew
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdPaste

Is there a way to copy the subform data as well?