D
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 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 (2).
I want to take the current count, add 1 and insert that into the
Package field on Subform2.
Thanks again!
Del
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 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 (2).
I want to take the current count, add 1 and insert that into the
Package field on Subform2.
Thanks again!
Del