Copy data from subform1 to subform2

[Mark]

I have a project management database and it has a form called Estimator that
calculates the cost of about 10 parts to a project. You can change parameters,
click a Calculate button and all the costs are recalculated. Estimator works
great!

One of the parts contains an itemized list of up to six components that can be
added up to arrive at the cost of that part. The components are listed in a
subform sort of like quantity, description and extended price. The components
are selected in Estimator.

There is another form called ProjectSale that is opened from Estimator. Once the
acceptable set of parameters are selected in Estimator and the project cost is
calculated, the Project Sale form is opened and the data in Estimator is
programatically entered into the project sale form. A subform needs to be added
to the project sale form to record the components that went into the estimate of
the one part discussed previously. Let's say we need to programatically enter
quantity, description and extended price. They are already in the subform in
Estimator. What is the easiest way to programatically copy them from there to
the subform in the project sale subform?

Thank you!

Mark

[Pieter Linden]

"Mark" <mm***@Earthlink.net> wrote in message news:<1i*****************@newsread3.news.atl.earth link.net>...

I have a project management database and it has a form called Estimator that
calculates the cost of about 10 parts to a project. You can change parameters,
click a Calculate button and all the costs are recalculated. Estimator works
great!

One of the parts contains an itemized list of up to six components that can be
added up to arrive at the cost of that part. The components are listed in a
subform sort of like quantity, description and extended price. The components
are selected in Estimator.

There is another form called ProjectSale that is opened from Estimator. Once the
acceptable set of parameters are selected in Estimator and the project cost is
calculated, the Project Sale form is opened and the data in Estimator is
programatically entered into the project sale form. A subform needs to be added
to the project sale form to record the components that went into the estimate of
the one part discussed previously. Let's say we need to programatically enter
quantity, description and extended price. They are already in the subform in
Estimator. What is the easiest way to programatically copy them from there to
the subform in the project sale subform?

Thank you!

Mark

Sounds like an append query should work. Just grab the PK from the
Estimate form, and run your append query.

[Pieter Linden]

"Mark" <mm***@Earthlink.net> wrote in message news:<1i*****************@newsread3.news.atl.earth link.net>...

I have a project management database and it has a form called Estimator that
calculates the cost of about 10 parts to a project. You can change parameters,
click a Calculate button and all the costs are recalculated. Estimator works
great!

One of the parts contains an itemized list of up to six components that can be
added up to arrive at the cost of that part. The components are listed in a
subform sort of like quantity, description and extended price. The components
are selected in Estimator.

There is another form called ProjectSale that is opened from Estimator. Once the
acceptable set of parameters are selected in Estimator and the project cost is
calculated, the Project Sale form is opened and the data in Estimator is
programatically entered into the project sale form. A subform needs to be added
to the project sale form to record the components that went into the estimate of
the one part discussed previously. Let's say we need to programatically enter
quantity, description and extended price. They are already in the subform in
Estimator. What is the easiest way to programatically copy them from there to
the subform in the project sale subform?

Thank you!

Mark

Append the records to the proper table and requery the rowsource of the subform?