Inserting data from one subform into another subform

[dtlabo]

Thank you in advance for any assistance!
I have a Access 2000 database in which we are keeping track of package
details for orders to be sent to customers. Example: We have an order
for Company XYZ and after all the parts are pulled they are packaged
into three cartons that will be shipped to the customer. I have a Form
that has two subform. Subform1 is for data display only. Subform2 is
for data entery. As each carton is packed it's weight and dimensions
are entered into subform2. Subform2 consist of the following fields
"Package"

(Example the first carton would be package 1, the second carton would
be package 2 etc.), "Weight". Dimensions", and "Pack Date". Subform1
shows the same package information and is updated after each line is
entered. Subform1 also has a couple calculated fields 1) Total Number
of Cartons (Simple a count of the cartons entered), and 2) Total
Weight.

What I would like to do is pull the Total Number of Cartons from
Subform1 (this is an unbound text box that counts the number of cartons
displayed in Subform1) add 1 to it and use that to populate the Package
field on subform2. This is just to cut down on the number of pieces of
data the packers have to enter.
Example: Say on the order for Comapny XYZ has 2 cartons that have
already been packaged, however the order is not yet complete. The
remaining parts will go into package 3. Subform1 shows the detail for
the first two packages and also show the current count of packages as
2. I want to take the current count (2), add 1 and insert that into the
Package field on Subform2.

Thanks again!
Del

[rkc]

dt****@yahoo.co m wrote:

What I would like to do is pull the Total Number of Cartons from
Subform1 (this is an unbound text box that counts the number of cartons
displayed in Subform1) add 1 to it and use that to populate the Package
field on subform2. This is just to cut down on the number of pieces of
data the packers have to enter.
Example: Say on the order for Comapny XYZ has 2 cartons that have
already been packaged, however the order is not yet complete. The
remaining parts will go into package 3. Subform1 shows the detail for
the first two packages and also show the current count of packages as
2. I want to take the current count (2), add 1 and insert that into the
Package field on Subform2.

From the Main form's code module it would be:
Me.Subform2.For m.Package.Value = Me.Subform1.For m.NumCartons.Va lue + 1

From either subform you would add Parent to the mix.
Me.Parent.Subfo rm2.Form.Packag e.Value =
Me.Parent.Subfo rm1.Form.NumCar tons.Value + 1