Update a subform from a subform (in a seperate form)

[inkman]

I have a Customer Orders Form[Orders] and a subform [Order Details]. My business has now changed such that 90% of customer orders are drop shipped so my purchse orders on my suppliers are identical to my customer orders (except price). I would like to enter my customer orders into my [Orderdetails]and then click a button to transfer the ProdID and Quantity to my Purchase Order Form (which has a sub form called [Inventory transactions]), this will save time. I have tried for a week (scouring the web for ideas) to get the Inventory transactions to accpt those two fields from the Order details subfrm. I can get the data to the Innventory Transactions table, but it doesn't show up. I have got the setfocus to the qty field on the Inventory tranasactions subform but it wil not take the data. Any suggestions gratefully received.

 

[MajP]

If you are getting your data into the table, but it is not on your form then you need to requery your form. You did not provide any code but after you insert your data into the table you probably need something like this to requery the subform records

forms("PurchaseOrders").subFrmCtlName.form.requery

in the above "subFrmCtlName" is the name of the subform control. A subform control has a form object inside of it thus you need to return the form inside the subform control.