Creator: Calculating and Recalculating Sum of Two Subforms

Creator: Calculating and Recalculating Sum of Two Subforms

We have a form with two subforms within it. I’m trying to run a loop through both subforms to calculate the sum total in a field that is separate from both subforms. How can I calculate the sum total of all “Rate” fields within both subforms? Also, I need to recalculate if/when the subforms are added/removed/edited…Thanks for your help!

*also see photo for subform field names
Main Form Name: Add_Job
Subform1 Name: Service
Subform2 Name: Materials
Currency Field: Total_Price