Re: calculation in a form

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 02/26/05 

Date: Sat, 26 Feb 2005 13:06:00 -0700

On Sat, 26 Feb 2005 18:36:34 GMT, "Garry"
<garry.fitzgerald@ntlworld.com> wrote:

>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

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]

Relevant Pages

  • Re: calling a module function
    ... A textbox on a form can have only one control source: ... field or an expression (a calculated field). ... Just redo the calculation whenever you need it, ...
    (microsoft.public.access.formscoding)
  • Re: Storing Calculated field...I know..I know...
    ... need to change any part of the fields that feed into the calculation, ... to store the calculated value. ... the control source of the final field. ... purpose it would create an additional 15-20 tables to store unnecessary ...
    (microsoft.public.access.forms)
  • Re: Storing Data
    ... Rather than doing the calculation as the control source of the control on ... your form, do it as a computed field in a query, and use that query as the ... do this I need to store the last service date. ...
    (microsoft.public.access.forms)
  • Re: How to build a calc based on option controls?
    ... What you store in the table depends on other factors. ... if this enddate calculation is being ... I think I would create a function even for a calculation ... >>>After Update event procedure or do I put it all under the Control Source ...
    (microsoft.public.access.formscoding)
  • Re: MaX number?
    ... GlobalSign digital certificate is a forgery and should be deleted without ... > clear on how to group all the 'textbox' together to do the calculation. ... >> me to use a real e-mail address in public newsgroups. ...
    (microsoft.public.access.forms)