Re: MainForm, SubForm and SubSubForm

From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 12/29/04 

Date: Thu, 30 Dec 2004 00:03:28 +0800

Any one calculated control can cause #Error in others. You may like to
eliminate them one by one to track which one is causing the error.

In tracking down the cause of the error, you may also need to know that the
Name of a subform control can be different from the name of the form that is
loaded into it (its SourceObject). 

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"an" <anonymous@discussions.microsoft.com> wrote in message
news:03ee01c4edbc$ef156d90$a401280a@phx.gbl...
> Thanks for your reply.
>
> Although it has made the suggested alteration, that I am
> thankful, it continues to give the same error and to cause
> conflict in other TextBoxes related of the SubForm,
> indicating # ERROR. If to erase the new formulae, the
> Textboxes remains start to indicate the correct values.
>
> I don't know if the conflict is because I have in the
> FormFooter of the SubForm, another one Textbox to effect
> another sum. (?)
>
> Many thanks.
> an
>
>>-----Original Message-----
>>So in the Form Footer section of your subsubform, you
> have a text box that
>>has control source of:
>>    =Sum([Field2])
>>where "Field2" represents the name of this field.
>>
>>Once you get that working as a stand-alone form, you can
> then refer to that
>>text box from the subform, ... and so on.
>>
>>
>>"an" <anonymous@discussions.microsoft.com> wrote in
> message
>>news:0e3a01c4eda8$ced487a0$a501280a@phx.gbl...
>>> Ooops!
>>> Return me #ERROR in TextBox on FormFooter of SubForm
>>>
>>> (Because, the TextBox where I have the value to sum in
>>> SubForm, already resulted of formulae to sum values of
>>> SubSubForm?)
>>>
>>> End now?
>>> More one thanks.
>>> an
>>>
>>>>-----Original Message-----
>>>>Open the Northwind sample database, and open the Orders
>>> Subform in design
>>>>view. You will see a text box in the Form Footer
> section,
>>> that has its
>>>>Control Source set to:
>>>>    =Sum([ExtendedPrice])
>>>>Then open the Orders form in design view. It brings back
>>> the subtotal onto
>>>>the main form, with a text box set to:
>>>>    =[Orders Subform].Form!OrderSubtotal
>>>>
>>>>That's what you need to do.
>>>>
>>>>"an" <anonymous@discussions.microsoft.com> wrote in
>>> message
>>>> news:0af301c4ecff$1710d050$a501280a@phx.gbl...
>>>>>
>>>>> I have a MainForm, SubForm and SubSubForm.
>>>>> In SubForm, I have a TextBox named TxtCustEstimTr with
>>>>> =[SubSubControlProj].[Form]![TxtCustEstimProj]
>>>>> where [TxtCustEstimProj] in FormFooter of SubSubForm
> is
>>>>> the SumEstimProj.
>>>>> Similary, I would like, in FormFooter of MainForm, a
>>>>> TextBox to Sum all values of TxtCustEstimTr, in
> SubForm,
>>>>> but I don't know how.
>>>>> Already I tried many hypothesis... nothing.

Relevant Pages

  • RE: Totals Row Not Summing
    ... to SUM, but it doesn't calculate a sum. ... Let's say your subform text box control is txtCost and it's ControlSource is ... I enabled the totals row on the two datasheet subforms, ...
    (microsoft.public.access.forms)
  • Re: Total from a subform
    ... Thank you that was the problem once I added the sum function to the formula ... Never base a calculation on a calculation, ... Create the calculated field in the form footer of the subform like ... Ensure to name the control a name you will remember such as ...
    (microsoft.public.access.forms)
  • Re: Automatic editing - or a bug in Access?
    ... > In a form with a subform, I want to show the sum of all calculations ... The sum control in the form should have the Control Source ...
    (microsoft.public.access.forms)
  • Re: Slow Code
    ... value in textbox Text171 on the subform, then set the value of this textbox ... executing within the mainform. ... run the expression in the subform, ... no point using code to hide/unhide the control; ...
    (microsoft.public.access.forms)
  • Only Access 2003 for this problem
    ... I have determined that by moving the calculated control to be AFTER the ... textbox), ... > I don't believe that a simple calculation in a control in the subform ... >> that if the first control in the subform is a textbox with a calculated ...
    (microsoft.public.access.forms)