I have a field on a form that calculates a total with VBA code. I want the field to recalculate everytime there is a change in either of two subforms as it is based on them. I'm having a tough time figuring out what event applies. I've tried OnEnter, Lostfocus, gotfocus, onExit for both the subforms and the main form but none have worked. I've also tried some fields in both forms...afterupdate and such. Where should I be looking for the correct event?
There are three fields in play. Two are being added together for a total. FieldOnMainFOrm + FieldOnSubform1 = TotalFieldOnMainForm.
The FieldOnMainForm is simply equal to FieldOnSubForm2.
I'd like ToitalFieldOnMainForm to update anytime there is a change on SubForm1 or SubForm2
Thanks