Re: calculation in a form

From: Steve Schapel (schapel_at_mvps.org.ns)
Date: 02/26/05 

Date: Sun, 27 Feb 2005 07:56:59 +1300

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. 

-- 
Steve Schapel, Microsoft Access MVP
Garry 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
> 
> many thanks Garry
> 
> 
>

Relevant Pages

  • 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)
  • Re: Error Message and not sure why Please help
    ... The thing is I need to know if I can have 2 differnet textboxes on a form ... > What's the Control Source of the form textbox? ... > (almost any calculation will be MUCH faster than a disk fetch); ... > in the control source of a Form or a Report textbox. ...
    (microsoft.public.access.queries)
  • Re: MaX number?
    ... Sorry I wasn't clear on which database I am using. ... clear on how to group all the 'textbox' together to do the calculation. ... > GlobalSign digital certificate is a forgery and should be deleted without ...
    (microsoft.public.access.forms)
  • Re: Code in database
    ... Garry Martin ... "Ryan Potratz" wrote in message ... > The string will contain the calculation 'thisfield*thatfield/anotherfield'. ...
    (microsoft.public.vb.general.discussion)
  • HOW TO SAVE DATA IN ACCESS & ORACLE TABLE FROM VISUAL BASIC FORM
    ... 2nd text box is Enter the 2nd number.(textbox name is T2) ... made two buttons which are SAVE & EXIT ... it will make calculation of two numbers whatever user will enter in ... on Private Sub cmdSave_Click ...
    (microsoft.public.access.queries)