Re-Tabbed Subform calculations in a main form.

[Ken]

Thanks for the sugestion Wolfgang.
I dont understand the refereance to Page.

I assumed that I have to refer to fom names.
Regards
Ken

Hello Ken.

1) I have created a subform "SF-VisitDates" in a main form called
"Engineers"
I have managed to display a calculated subform value "=Sum([G_Tot])"
from the subform form footer and named it "SG_Total" by putting the
following into a text box in the main form,
"=[SF-VisitDates].Form!SG_Total" it displays succesfully.

2)I have also created another form that has tab controls in it with the
subform "SF-VistDates" embeded in it. The tab control is called
"TabCtl117" How do I get the main form to display a calculated value
from "SF-VistDates" which is in "TabCtl117". I have tried all sorts
of combinations e.g. "=[TabCtl117]![SF-VisitDates].Form!SG_Total"
but it keeps crashing and tries to send a report to Microsoft.

Try this (Assuming that the name of the page is MyPage):
=[TabCtl117].Pages!MyPage.Controls![SF-VisitDates].Form!SG_Total

-
Regards,
Wolfgang

 

[Al Camp]

Ken,
A subform on a tab control is considered to be on the main form just like
any other contol. So... what worked for Form1 will work for Form2
(use your names)
Forms!frmForm2![SF-VisitDates].Form!SG_Total

By the way, a tab control's "tabs" are referred to as Pages in Access.
When you want to add another "tab" to a tab control, you actually add a
"Page"
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Thanks for the sugestion Wolfgang.
I dont understand the refereance to Page.

I assumed that I have to refer to fom names.
Regards
Ken

Hello Ken.

1) I have created a subform "SF-VisitDates" in a main form called
"Engineers"
I have managed to display a calculated subform value "=Sum([G_Tot])"
from the subform form footer and named it "SG_Total" by putting the
following into a text box in the main form,
"=[SF-VisitDates].Form!SG_Total" it displays succesfully.

2)I have also created another form that has tab controls in it with the
subform "SF-VistDates" embeded in it. The tab control is called
"TabCtl117" How do I get the main form to display a calculated value
from "SF-VistDates" which is in "TabCtl117". I have tried all sorts
of combinations e.g. "=[TabCtl117]![SF-VisitDates].Form!SG_Total"
but it keeps crashing and tries to send a report to Microsoft.

Try this (Assuming that the name of the page is MyPage):
=[TabCtl117].Pages!MyPage.Controls![SF-VisitDates].Form!SG_Total

-
Regards,
Wolfgang

 

[Ken]

Thanks Al.
I will give it a go when I get back to the database.
Regards
Ken

Ken,
A subform on a tab control is considered to be on the main form just
like any other contol. So... what worked for Form1 will work for Form2
(use your names)
Forms!frmForm2![SF-VisitDates].Form!SG_Total

By the way, a tab control's "tabs" are referred to as Pages in Access.
When you want to add another "tab" to a tab control, you actually add a
"Page"
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Thanks for the sugestion Wolfgang.
I dont understand the refereance to Page.

I assumed that I have to refer to fom names.
Regards
Ken

Hello Ken.

Ken wrote:
1) I have created a subform "SF-VisitDates" in a main form called
"Engineers"
I have managed to display a calculated subform value "=Sum([G_Tot])"
from the subform form footer and named it "SG_Total" by putting the
following into a text box in the main form,
"=[SF-VisitDates].Form!SG_Total" it displays succesfully.

2)I have also created another form that has tab controls in it with the
subform "SF-VistDates" embeded in it. The tab control is called
"TabCtl117" How do I get the main form to display a calculated value
from "SF-VistDates" which is in "TabCtl117". I have tried all sorts
of combinations e.g. "=[TabCtl117]![SF-VisitDates].Form!SG_Total"
but it keeps crashing and tries to send a report to Microsoft.

Try this (Assuming that the name of the page is MyPage):
=[TabCtl117].Pages!MyPage.Controls![SF-VisitDates].Form!SG_Total

-
Regards,
Wolfgang