Totals on a form (1 Viewer)

[chellebell1689]

Hello,

I have a form with some tabs and one is for tithing. On the tithing tab I have the member's tithing history set up (via subform), but I want to be able to view the member's total giving for a specific month and year. I can select what month/year via a drop down and then the system will update a box right next to the drop down to show what the total is. How do I set this up? The subform is based on my tithing table which has a field for the month, year, date, and amount given. (I know you can pull the year and month from the date, but I'm still learning VB, and this is currently easier for me.)

Let me know if you need more info. Thanks in advance for the help.

**EDIT**
Oh the subreport & the master form are linked via FamID#. If you provide code, please explain what it is doing, I learn better that way. Thanks!!

 

[llkhoutx]

Build a related subform for tithing history with the "datasource" property value filtered by the desired period.

 

[chellebell1689]

Thanks! I was just wondering if that would work! :-D