Hello,
I have a form which is basically a Student ledger. A subform shows payments made. At the bottom of the form, I have some controls that summarize the student's account, including a control called PaymentsMade. The control source is = [Forms]![frmStudentsPaymentLedger2]![subfrmPayments]![SumPaymentAmount].
It works perfectly when a student has at least one payment, but I keep getting #Error whenever a student has not made any payments. Entering a $0 payment for the student solves the problem, but obviously, that is a poor option.
I have tried:
Nz([Forms]![frmStudentsPaymentLedger2]![subfrmPayments]![SumPaymentAmount],0) as well as
IIF([Forms]![frmStudentsPaymentLedger2]![subfrmPayments]![SumPaymentAmount] Is Null, "0", [Forms]![frmStudentsPaymentLedger2]![subfrmPayments]![SumPaymentAmount]) but neither solved the problem.
Any suggestions would be greatly appreciated.
Thanks in advance,
Al