Implementing Math Formula

[jbarrum]

RG, I can see that you used the Nz function in order to give each field numerical value of "0" if it contains a NULL. However, I am unclear as to what the "txt" preceeding each field name is doing. Can you explain.

[cwwaicw311]

The formula is working perfectly, thank for the help. But I was wandering since the control source of NewBalance is use for the formula, how is the value of NewBalance can be transfer to the NewBalance field in my table?

[RuralGuy]

Access has a nasty habit (in my opinion) of naming controls on a form the same name as the ControlSource (field name) of the control. As a result it is difficult to specify which one you are referring to. That is why I prepend the txt to the name of a TextBox control on a form.

[RuralGuy]

The formula is working perfectly, thank for the help. But I was wandering since the control source of NewBalance is use for the formula, how is the value of NewBalance can be transfer to the NewBalance field in my table?

I believe this link should be useful: http://allenbrowne.com/casu-14.html

[jbarrum]

Thanks for sharing that RG, I am learning VBA scripting one step at a time and that certainly makes since.