subform details from one form to create another form

subform details from one form to create another form

Hi Guys,

i am looking to add subform details from one form to create another form.

i.e

Form ONE
has a Subform

Form TWO
has all the same fields as the subform in Form ONE

On every row entry of Form ONE subform i want it to insert as a row into Form TWO

insert into Form Two
[
FormTWOfield1=row.FormONESubformfield1
FormTWOfield2=row.FormONESubformfield2
FormTWOfield3=row.FormONESubformfield3

]

I hope this is easy to understand and im hoping you can help me to resolve this issue.

Thanks