calculation in a form

  • Thread starter Thread starter Garry
  • Start date Start date
G

Garry

Hi all

How can I look up the result of a calculation in a form that is closed

so I can view the result in another

many thanks Garry
 
Garry,

If you mean you have a calculated control on a form, i.e. an unbound
textbox with its Control Source set to an expression that does a
calculation, then this is not available if the form is not open. An
alternative approach may be to use a Domain Aggregate Function on the
second form, to return the calculated value from table or query data.
If you would post back with more details, what the calculation is all
about, and example, someone may be able to help further.
 
Hi all

How can I look up the result of a calculation in a form that is closed
so I can view the result in another
Click to expand...

You can't. Information on a closed form is not accessible.

Simply redo the calculation - copy and paste the expression in the
Control Source of the textbox on the first form into the control
source of a textbox on the second form, or otherwise recapitulate the
calculation. It's neither necessary nor desirable to store the
calculated value in any table.

John W. Vinson[MVP]
 
Back
Top