Capturing a calculated control
Posted on 2014-01-31
I have an unbound calculated control [Z] on a form. It gets it's value from calculated control A +calculated control B +calculated control C +calculated control D . A, B, C & D get their values from subforms within the form. All works fine when the form is visible and on the current record but now I want to use the value of control [Z] in a report.
What is the most reliable way to get that value into a field (lets say [Total]) for later use bearing in mind that all calculated controls change with almost every change of any field in the form or subform.
Normally I would create a calculated field in the forms underlying query. But it is far too involved and not really possible in this instance.