copying data from subform to subform

S

Simon

I know what i am doing is bad practice as its duplicating data but
there is a reason why i am duplicating it, but its hard to expain

I have a form with two datasheet subforms
There will be data in the top subformform (frmManufactureParts) and i
want to copy it to the botton subfform (frmManufacturePartsUsed)


I want a o click button the the form to do the copy


i currently have the following code


frmManufacturePartsUsed.Form!ProductCode =
frmManufactureParts.Form!IDNumber
frmManufacturePartsUsed.Form!Quantity =
frmManufactureParts.Form!Quantity


This coe only copys the bottom line of data from the datasheet.


Is there a way to make it copy all the data


Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copying data from subform to subform 1
copying some data from one subform to anther 3
copying data from subform to subform 1
Add additional information to excel form after original data entry 0
Populate main form from subform record 0
Adding data to MS Access from csv file 0
Subform Datasheet Total Row 3
Adding data to Subform and save and running a total price calc 0

Top