Else If statement needed.If value is zero then show $0.00

[burrina]

I refer to my subform to get the total of payments made and then subtract this amount from the Order Total (main form). Problem is, what if NO payments have been made? Then the Order Total shows nothing.


=TPaymentSub.Form!SumPayment This is the control source for the textbox that shows the sum of payments made. It uses the subform/SumPayment as it's control source.textbox is located on the main form. textbox is named txt102 subform SumPayment is named SumPayment. It is unbound but uses as it's control source =Sum([Payment]) Also it's default value is set to =Nz([SumPayment],0)

My Order Total shows nothing if SumPayment is zero., txtOrderTotal is the name of the control and control source is =Nz([txtOrderSubtotal])+Nz([FreightCharge])+Nz([Taxes])-[txt102]

subform shows nothing as well if no payments have been made?

How can I make the subform show a 0.00 value if NO payments have been made?


I have tried using this code on the OnCurrent and BeforeUpdate Events with NO success;
If IsNull(SumPayment) Then ' Set Value To Zero if has no value
[SumPayment] = "0"
End If

I even add a textbox to my main form and set value to zero,i.e. $0.00 and have the Order Total add it back and no success either?? Sheeesh !

[pbaldy]

Try

nnz function

[burrina]

That didn't work, unless I did not do it right.

[pbaldy]

I have no idea what "didn't work" means, and not knowing exactly what you did, no way of knowing what you may have done wrong.

[burrina]

Thanks, I was just fixing to post back. Sorry for the bad post. I did resolve the situation by simply adding another field and using it as a Grand Total, removing the subtract SumPayment from the txtOrderTotal . So now the Order Total shows the Order Total and NOT the Applied Payments. However, the Grand Total reflects the Order Total Minus the sum of all payments. Grand Total equals; =[txtOrderTotal]-[txt102] (Order Total Minus Payments)

"Sometimes the solution is not to fix the problem, but instead use a different approach"

You heard it here first,

Many Thanks.