Copy data from one subform to another in another form

[dash8x]

Hi, How can I copy data from a subform in one form to another subform in another form using code?

Here I have a form called "Customers" which have a subform called "Unpaid Orders" which display the customer's unpaid orders. Both the form and subform is created from seperate tables. What I want to do is create a button in each record in "Unpaid Orders" so that when I click it a new record is opened in "Orders" form with the data in the "Unpaid Orders" fields copied to the fields in "Orders Subform".

Please help...

 

[PaulJR]

You can use the 'DoCmd.OpenForm' command to open the Unpaid Orders form.

To copy the records over it should be something like this:

[Forms]![Orders Subform]![fieldname1] = [Forms]![Unpaid Orders]![fieldname2]