I have a mainform with a subform.
As I often need to input similar records in the subform, I made 2 button to copy the record and then amend some fields so that it becomes a new record. For copy I have this button:
Me.subform.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70...