Sum([Bound Control]) not working. Not even displaying.

HI Experts!! I have a field called PmtAmount in a subform. In the footer I have a field named Sum([PmtAmount). The field is displayed but there is no value nor is there an #Error displayed which would indicate I've done something around. I have used this in almost every application I've developed. I'm stumped. Any ideas would be appreciated.
Eileen MurphyIndependent Application DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Haris DulicIT ArchitectCommented:
is there a typo ?

Sum([PmtAmount) should be Sum([PmtAmount])
Eileen MurphyIndependent Application DeveloperAuthor Commented:
Good catch but no -- It's correct on the form -- I typed it wrong here :)
Rey Obrero (Capricorn1)Commented:
is there an equal sign (=) before the formula ?
=Sum([Bound Control])

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Price Your IT Services for Profit

Managed service contracts are great - when they're making you money. Yes, you’re getting paid monthly, but is it actually profitable? Learn to calculate your hourly overhead burden so you can master your IT services pricing strategy.

Eileen MurphyIndependent Application DeveloperAuthor Commented:
Yes the equal sign is there.
Gustav BrockCIOCommented:
You may have to requery it from the main form at the OnCurrent event:


Make sure that the field specified in the SUM(FieldName) is the name of the field as it appears in the underlying table or query, (not the name of the textbox or other control that displays it on your form).
Eileen MurphyIndependent Application DeveloperAuthor Commented:
The field name is correct. It is the bound field name.  I've tried repaint/requery/refresh all to no avail. I even created a new form to see if there was a corruption and still no dice. This is making me nuts.
Rey Obrero (Capricorn1)Commented:
<It is the bound field name>

if you are displaying the total, the textbox should be UNBOUND.
Eileen MurphyIndependent Application DeveloperAuthor Commented:
I just noticed this issue is occurring on ALL forms -- not just the one I had originally mentioned.
Eileen MurphyIndependent Application DeveloperAuthor Commented:
The field is: = Sum([the bound field name]) as I have always done. As I said above -- I just noticed it's happening throughout the application. I'm going to run a repair on Office to see if that might do something. This is beyond strange.
Do you have other totals in this subform footer?  Sometimes problems in one calculation can make the rest of the (previously working) calculations fail.
Eileen MurphyIndependent Application DeveloperAuthor Commented:
OKAY! I did a repair and now all the totals are working and visible. What the heck? Thank you all for your input. I will share the points among you for you help. This was a new one for me!!
Rey Obrero (Capricorn1)Commented:
did the C&R fixed the error?
Eileen MurphyIndependent Application DeveloperAuthor Commented:
As always, thanks for your help.
Eileen MurphyIndependent Application DeveloperAuthor Commented:
C&R did not --- but a Repair on the Office Installation did the trick.
Also, you haven't responded to Gustav's post.  Did you try his requery suggestion?

For most of the other suggestions here, I would have expected to see #error or #name rather than nothing at all.
Sorry,  missed some posts.  I'll blame it on my cellphone   :)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.