If IsNull Value, Then need to be Zero

[burrina]

I am trying to calculate payments from a subform and then have them subtracted from the total on my main form.
Main form name is OrderDetails, subform is named OrdersPaymentSub

1. =[txtOrderSubtotal]+Nz([FreightCharge])+Nz([Taxes])-[txt102] ' txtOrderTotal Minus Sum of Payments,i.e. txt102
2. =TPaymentSub.Form!SumPayment ' Sum of Payments on subform. Default value is 0

1. equals the total on main form minus the sum of payments on the subform.


2. equals the sum of payments on the subform

Problem is that if NO payments are made, it makes my formula not work.
1. main form will have no value from subform

I have tried the Nz thing with no success.
Such as =Nz([txt102],0)

[June7]

I can't replicate the issue. If you want to provide db for analysis, follow instructions at bottom of my post.

[burrina]

If you would personally look at it then I would not mind sending,otherwise I regress but to send a scaled down version.
I am still a little ways off from being done. Reports are giving me fits.I have sorted out the Labels and messages. I am a little concerned about my structure, if I have it right.Everything seems to be working ok. I will get back with you no doubt soon.

Thanks s much for all you help.