I have the same issue.
FireStrike, where exactly do I need to put this code and what other SQL statement would I need to make sure the subform gets updated?
My subform (call it subform1) is based on a query that has a Totals field (Sum), which does not update as I change data in subform2...