Unanswered: How to retreive data from one subform into another subform!
I have subform 1(mod1)
it has another subform(mod2) and a text box(UNIT COST)
subform(mod2) has another text box(quantity purchased and a subform(mod3)
mod3 has a calculate button and an empty text box(extended cost)
unit cost is retreived from a database table
quantity purchase is entered by the user
and then they are both multiplied and displayed in the extended cost text box in mod3!
What should I code behind the calculate button on mod3 to retreive the values in unit cost textbox on mod1 and the quantity purchased text box on mod2, into mod3 variables to multiply the values and display the results in the extended cost text box?
please PM me for more detailed info. if you think you have a solution!