Amount in form needs to equal disbursements in subform

[mfmathes]

An amount is entered in the main form, but I need the sum of entered disbursements (in subform) to equal the original amount. If totals don't equal, I need a popup. If totals equal, I need to save the record and enter a new one.

[June7]

Need a popup for what - a message?

[mfmathes]

Yes. A popup to indicate out of balance.

[June7]

Would need code in an event (form close?) to compare values. These values involve aggregate calcs. Subform in continuous view. Textbox in form footer with controlsource: =Sum([amount field])

Then code:
IIf Me.maintextbox <> subformsumtextbox Then
MsgBox "Not in balance"
Else
DoCmd.Close
End If

referencing textbox in subform can be tricky. I always name subform container control different from the object it holds, like ctrDetails.
Me.ctrDetails.Form.txtSum