copying data from tabel to table

[Simon]

I have 3 main tables
tblParts (HotTubsCode, ProductCode, Quantity)
tblManufacture (ManufactureID, HotTubCode, Date)
tblManufactureParts ( ManufactureID, ProductCode, Quantity,
SerialNumber)

What I have is form based on tblManufacture that has manufactureID (
Autonumber) and a lookup box for HotTubCode.

I then want a sub form that is a datasheet on this form based on
tblManufactureParts
I would like a click button on the form that will copy the data in
tblParts into tblManufactureParts but only the data that has
HotTubsCode what was on the form from the look up box. Therefore the
data will be displaced in the sub form.
Once it's in the sub form I am able to add serial numbers and change
it if I need to.


Can any one tell me how to do this?

Thanks

Simon

 

[Steve Schapel]

Simon,

I think this is similar to the question you asked here just a few hours ago?

 

[Simon]

I have rewwored it to make to clear. as it taking me some time to work
out what im trying to do

 

[Steve Schapel]

Ah, ok thanks. Well, just a hint for the future... if you need to
modify or add to what you have already written, it is probably less
confusing if you keep your updated comments in the original thread. Thanks.