By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,474 Members | 1,283 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,474 IT Pros & Developers. It's quick & easy.

Copy data from subform1 to subform2

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"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.
Nov 13 '05 #2

P: n/a
"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?
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.