Copy a record with subform

[Guest]

Hello,
Could anyone help me out with code for copying a record in addition to its
subform contents?
Here is the info:

Main Form: Lease Inventory FORM
Based on Main Table: Lease Inventory TABLE

Subform: Partner WI SUBFORM
Based on Subtable: Partner WI SUBTABLE

The main form and subform are linked by the field "Field" (I know that's
confusing,sorry)

Thank you so much I've been working on this one for weeks and I'm not making
any headway!

 

[Guest]

I forgot to add that I have no primary keys in these tables
thank you!