Copy data from one subform to another in another form (1 Viewer)

dash8x

New member
Local time
Today, 14:18
Joined
Jan 15, 2009
Messages
1
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

Registered User.
Local time
Today, 10:18
Joined
Jun 16, 2008
Messages
133
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]
 

Users who are viewing this thread

Top Bottom