Copying data from one sub-form to another

[Martink]

I have a sub-form on one form which I want to copy data from onto another sub-form on another form. I have a button on the form which loads the second form and creates a new record at which point I want to copy the relevant data from the first sub-form to the second one. How is this possible?

Thanks for the help Martin.

 

[Pat Hartman]

Why are you duplicating data?

 

[jca]

Try this but change the form, subform and field name first:

[Form_SecondForm].[SubForm]!FieldName.Value = [Form_FirstForm].[SubForm]!FieldName.Value

Put a line like this for each field you want to copy