append data from one form to another

[Adam1970]

Hi

I have a parent form "SalesForm" with a subform "SalesDetaiForm" i have identical parent & subform but named "PurchaseForm" & "PurchaseDetailForm".
what i need to happen is once a button is pressed on the sales form it opens up the "purchaseform" & subform and adds the data from the "salesdetailform" to the PurchaseDetailForm.
fields to be copied and added are as follows.


ItemID
Quantity
QtyUnit
the following can be null values
Shape
Dimension1
Dimension2
Comments

I was toying with the idea of just using the "salesdetailform" and adding it to the "purchaseform" but would like purchase & sales records kept separate.
Many thanks for your help
Adam

[Welshgasman]

You do not add data to forms, you add data to tables that a form is based on. So use an append query.

You could have one table by the sounds of it and a field to identify Sales, Purchases. However I am not sure why you want Sales added to Purchases?

[Adam1970]

Hi
The sales details (products) would be added to purchasing for ordering.
I would need the salesID to control the append
For example only append the open form data, and not the entire salesdetail table

[Welshgasman]

Hi
The sales details (products) would be added to purchasing for ordering.
I would need the salesID to control the append
For example only append the open form data, and not the entire salesdetail table

OK, so use the SalesID as your append criteria?

[Adam1970]

perfect thanks, just learning as i go

[Adam1970]

ive come across another issue. Append works fine it adds the data to the "PurchaseDetailT". what i need to happen is once the data has been appended, the parent form "PurchaseT" which contains the child form "PurchaseDetailT" opens with the appended details and to allow the parent form to be completed ie add vendor name etc. at present the appended data isnt creating a purchaseID in the "purchaseDetailT" as it does not exist yet.

[Welshgasman]

So just open the form?
https://learn.microsoft.com/en-us/of...docmd.openform

[Adam1970]

i have the following codes
DoCmd.OpenQuery "appendpurchasedetailq"
DoCmd.OpenForm "purchaseForm", , , "SalesID=" & SalesID
this opens the form however it does not create the "purchaseT" primary key in the "PurchaseDetailT" to create the link between "purchaseT" & "purchasedetailT". I have added the "purchaseID" to the "purchasedetailform" and have added default value =[Forms]![PurchaseForm]![PurchaseID]. it pulls the number into the form field but does not populate to "purchasedetailT" .

I have a check box on the query which only appends the true selections to the "PurchaseDetailT" if i have 10 items that are purchased from 2 vendors i would append the 1st items. when i attempt to append the 2nd items it adds it to the bottom of the 1st items, this is due to the same "SalesID" im using for the append criteria.