Calculated total on subform will not display on main form

[Shannan Casteel via AccessMonster.com]

I have a subform named "sbfrmParts " with a list of parts along with the
quantity and price. I have used a text box in the subform's footer and set
the control source to "=Sum([NET PRICE]*[Quantity])". I set the format to
display currency. This text box is called "SubformTot al", and is visible
property is set to "No". On the main form I have made another text box and
set its control source to "=[sbfrmParts].Form!SubformTo tal".

When I enter some parts everything works perfectly until I look at the text
box on the main form. It only displays "#Error".

What is wrong?

Any suggestions?

Shannan Casteel
--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200508/1

[Wayne Morgan]

A calculated control will update itself when you change the other controls
it is based on if those controls are on the same form. When they are on a
different form, such as a subform, then you need to tell the calculated
control to update. To have it update after you add each new record to the
subform, in the subform's Current event try:

Me.Parent.NameO fControlOnMainF orm.Requery

--
Wayne Morgan
MS Access MVP
"Shannan Casteel via AccessMonster.c om" <fo***@AccessMo nster.com> wrote in
message news:53******** ***@AccessMonst er.com...

I have a subform named "sbfrmParts " with a list of parts along with the
quantity and price. I have used a text box in the subform's footer and
set
the control source to "=Sum([NET PRICE]*[Quantity])". I set the format to
display currency. This text box is called "SubformTot al", and is visible
property is set to "No". On the main form I have made another text box
and
set its control source to "=[sbfrmParts].Form!SubformTo tal".

When I enter some parts everything works perfectly until I look at the
text
box on the main form. It only displays "#Error".

What is wrong?

Any suggestions?

Shannan Casteel
--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200508/1

[Shannan Casteel via AccessMonster.com]

Wayne,

Thanks for your reply. I tried entering "Me.Parent.Main FormTotal.Reque ry" in
the OnCurrent event of the subform, but it still returns "#Error" in the
MainFormTotal text box on the main form. My subform is based on a query.
Don't know if that matters, just thought I'd tell you.

Thanks for the help.

Wayne Morgan wrote:

A calculated control will update itself when you change the other controls
it is based on if those controls are on the same form. When they are on a
different form, such as a subform, then you need to tell the calculated
control to update. To have it update after you add each new record to the
subform, in the subform's Current event try:

Me.Parent.Name OfControlOnMain Form.Requery

I have a subform named "sbfrmParts " with a list of parts along with the
quantity and price. I have used a text box in the subform's footer and

[quoted text clipped - 14 lines]

Shannan Casteel

--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200508/1

[Wayne Morgan]

Going back to your original statement, the brackets should be as follows:

=sbfrmParts.For m!SubformTotal

On my main form textbox which refers to a control on the subform, Access
tried adding brackets but it worked after I removed them. It usually adds
what it needs, but not always and sometimes too much. Also, sbfrmParts
should be the name of the subform control on the main form, not the name of
the subform itself; however, they may both be the same.

--
Wayne Morgan
MS Access MVP
"Shannan Casteel via AccessMonster.c om" <fo***@AccessMo nster.com> wrote in
message news:53******** ***@AccessMonst er.com...

Wayne,

Thanks for your reply. I tried entering "Me.Parent.Main FormTotal.Reque ry"
in
the OnCurrent event of the subform, but it still returns "#Error" in the
MainFormTotal text box on the main form. My subform is based on a query.
Don't know if that matters, just thought I'd tell you.

[Bob Quintal]

"Shannan Casteel via AccessMonster.c om"
<fo***@AccessMo nster.com> wrote in
news:53******** ***@AccessMonst er.com:

Wayne,

Thanks for your reply. I tried entering
"Me.Parent.Main FormTotal.Reque ry" in the OnCurrent event of
the subform, but it still returns "#Error" in the
MainFormTotal text box on the main form. My subform is based
on a query. Don't know if that matters, just thought I'd tell
you.

Thanks for the help.

An alternate approach is to leave the textbox on the main form
unbound, and put code in the subform's AfterUpdate Event to set the
textbox on the mainform's value

e.g. parent!subformT otal = me.subformTotal

--
Bob Quintal

PA is y I've altered my email address.

[Shannan Casteel via AccessMonster.com]

I tried deleting the brackets around the formula, but Access just keeps
adding them back in. How'd you do that.

Shannan

Bob Quintal wrote:

Wayne,

[quoted text clipped - 6 lines]

Thanks for the help.

An alternate approach is to leave the textbox on the main form
unbound, and put code in the subform's AfterUpdate Event to set the
textbox on the mainform's value

e.g. parent!subformT otal = me.subformTotal

--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200508/1

[Shannan Casteel via AccessMonster.com]

I also tried Bob's approach, but it didn't seem to do anything. When I went
back to the main form the text box was blank.

Shannan

Bob Quintal wrote:

Wayne,

[quoted text clipped - 6 lines]

Thanks for the help.

An alternate approach is to leave the textbox on the main form
unbound, and put code in the subform's AfterUpdate Event to set the
textbox on the mainform's value

e.g. parent!subformT otal = me.subformTotal

--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200508/1

[Shannan Casteel via AccessMonster.com]

Guys,

I went to the Northwind sample database and checked all the syntax and it was
exactly the same as mine. I don't know what is wrong. Something in
properties maybe? This is driving me nuts.

Shannan

Shannan Casteel wrote:

I also tried Bob's approach, but it didn't seem to do anything. When I went
back to the main form the text box was blank.

Shannan

Wayne,

[quoted text clipped - 7 lines]

e.g. parent!subformT otal = me.subformTotal

--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200508/1

[Wayne Morgan]

If both methods aren't working, then I would suspect that one of the
controls' or forms' name is wrong.

--
Wayne Morgan
MS Access MVP
"Shannan Casteel via AccessMonster.c om" <fo***@AccessMo nster.com> wrote in
message news:53******** ***@AccessMonst er.com...

Guys,

I went to the Northwind sample database and checked all the syntax and it
was
exactly the same as mine. I don't know what is wrong. Something in
properties maybe? This is driving me nuts.

[Shannan Casteel via AccessMonster.com]

Wayne,

Here is how it is setup. I went and double checked just to be sure.

Subform Name: sbfrmParts
Main Form Name: frmClaim
Subform text box name: SubformTotal
Main Form text box name: MainFormTotal
Main Form text box control source: = [sbfrmParts].Form!SubformTo tal

I could not get those last set of brackets to go away. The text box on the
main form still displays "#Error".

What's wrong?

Wayne Morgan wrote:

If both methods aren't working, then I would suspect that one of the
controls' or forms' name is wrong.

Guys,

I went to the Northwind sample database and checked all the syntax and it
was
exactly the same as mine. I don't know what is wrong. Something in
properties maybe? This is driving me nuts.

--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200508/1