K
katelin0429
Hello - I am making a form (with subforms) to enter daily batch/deposit
information. I put a Close button on the form, which I would like to do a
"check" before it closes the form. There are three fields included:
TotalDeposit, which is the Sum of CashAmt+CheckAmt
TotalBatch, which is keyed in manually
TotalVariance, which is the sum of all the variance amounts (Continuous Form)
I want Close button to do TotalDeposit - BatchAmt - Total Variance if it
doesn't = 0 then a msgbox with "Doesn't balance" comes up. What is the best
way to do this? Should I use the calculated fields or each individual field?
What Event should I use? I pretty lost on this one, so the more help I get
the better. Thanks so much!!
information. I put a Close button on the form, which I would like to do a
"check" before it closes the form. There are three fields included:
TotalDeposit, which is the Sum of CashAmt+CheckAmt
TotalBatch, which is keyed in manually
TotalVariance, which is the sum of all the variance amounts (Continuous Form)
I want Close button to do TotalDeposit - BatchAmt - Total Variance if it
doesn't = 0 then a msgbox with "Doesn't balance" comes up. What is the best
way to do this? Should I use the calculated fields or each individual field?
What Event should I use? I pretty lost on this one, so the more help I get
the better. Thanks so much!!