Hello All:
I honestly try and try to figure these things out for myself but after banging my head for so long reading forums and trying all kinds of things it is now time to reach out.
I will try to initially explain my issue and see where we go from there.
I have one Form - frmStudentRevenue with two subforms - frmfees and frmpayments.
frmFees -- The Total at the bottom of the form works great in summing the amount column.
frmStudentRevenue -- There is a hidden text box that displays the Total text box from frmFees.
frmPayments -- The Total at the bottom of the form also works great in summing the amount column.
When the Form is loaded the Outstanding balance produces the proper amount -- Total of frmPayments - Total of frmFees (though frmStudentRevenue).
Any changes made on the frmPayments Amount produces the correct result.
The Refresh button also produces the correct results.
My problem comes when I need to Add/Delete/Change a Fee Amount from the frmFees.
The Total of frmFees and frmStudentRevenue change but the Outstanding balance on frmPayments does not.
I'm at the point now where I have the After Update trigger event attached to the amount on frmfees
Private Sub Amount_AfterUpdate()
Forms!frmStudentRevenue.frmPayments.Form.Requery
End Sub
Now what happens is that when I change a value on frmfees the Outstanding balance does not update until I make another change.
So I think that I am close but just can't figure out where I need to attach the trigger and what to attach to this trigger.
Thanks in advance