Microsoft Access 2010 Sub Form summing issue after upgrade from 2003

I have a simple sub form which displays only a few records of dataset. It also has a simple sum of one of the fields “=sum([Fee])”  in the form footer.

In Access 2003 the sum was always calculated and visible.  Now in 2010 the sum is only visible if the last record is displayed in the scrolling region. For example if my dataset  contains 35 records, and I am only displaying 3 records, I have to click the "Last Record" navigation button in order to finally get the sum to calculate and display.

I need the sum to calculate and display immediately upon my form rendering.

There must be a new property that I am unfamiliar with in 2010 that will allow me to adjust for this.

Thank you
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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.

Try to use the DSum function as illustrated below:


I have no this issue with Access 2010. Same sums are calculated immediately. May be you can upload this form?

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
I agree - this is not  directly an issue with A2010.  There must be something about the form, or there has been a problem in any conversion that has been done (if any).
EpistrophyAuthor Commented:
That is good information to know that it is not an  Access 2010 issue.  I will do some more testing on my end. I will build a similar form as a test and see if it works as it should.  I will get back to everyone.

Thank you,
EpistrophyAuthor Commented:
I simply rebuilt the forms from scratch and it worked.  This was a straight conversion from 2003 to 2010 so I thought it might be related to some other VB quirks I had to adjust in my code. I wish I had a better answer but it was hlepful to know that that it was not a conversion issue.
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 Applications

From novice to tech pro — start learning today.