Error with form calculation

[hamzack]

Hi!

I've encountered another stumbling block. My form is almost done except for some minor details. However, one calculation does not work even when I use the correct terms.

This calculates the tuition balance per customer based on data from 2 subforms on the main form: sbfTuitionAccount and sbfTuitionPayment.

My formula is =Nz(sbfTuitionAccount.Form![txttotaltuitionpayable])-Nz(sbfTuitionPayment.Form![txttotaltuitionpaymenttotal])

I've counterchecked all form and control names, however, when I test it, I only get a '#Error ' in form view. A similar formula has proven functional in another form. Do you have any ideas as to what the problem is?

Thanks!

 

[MarkK]

You need to push two parameters into ye olde Nz function.
Nz(<expression>, <result-if-null>)