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

Simon,

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

--
Steve Schapel, Microsoft Access MVP

Simon wrote:
> 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
>

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


Steve Schapel wrote:
> Simon,
>
> I think this is similar to the question you asked here just a few hours ago?
>
> --
> Steve Schapel, Microsoft Access MVP
>
> Simon wrote:
> > 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
> >

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.

--
Steve Schapel, Microsoft Access MVP

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