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