MainForm, SubForm and SubSubForm

[an]

Hello!

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.

Thanks in advance.
an

 

[Allen Browne]

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]

Thanks for your help.

(Sorry for my delay)
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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

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.

Thanks in advance.
an

.

 

[an]

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

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.

Thanks in advance.
an

.

 

[Allen Browne]

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

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.

Thanks in advance.
an

.

 

[an]

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.


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.

Thanks in advance.
an


.

.

 

[Allen Browne]

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.

Reply to group, rather than allenbrowne at mvps dot org.

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.

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.

message

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.

 

[an]

AB,
Many thanks for all.
Have you a Good New Year!
an

-----Original Message-----
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.

Reply to group, rather than allenbrowne at mvps dot org.

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.


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.

message

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.

.