reference totals on a datasheet from the main form

I have a form with a datasheet on it that I have sum totals using the totals row.  I would like to reference these totals so I can use them in additional calculations on my main form that will be updated as a change the filters on the datasheet.
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
I don't think you can get to those via code, so you'd have to use a different method. Many devs use a hidden textbox field in the Footer of the form (which can also be hidden), with the ControlSource set to Sum the desired field:


So if i were to name this field "txSum_Sales", I could then refer to that field anywhere on my form:

Me.SomeOthercontrol = "The Total Sales = " & Me.txSum_Sales
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.