Hi,

What I need to do is create a "balance" text box on one of my forms, which involves a simple calculation using several fields. My question is how do I do the calculation, and then put the result into a field called "balance" in my table?

If I set the control source to the calculation, the balance comes up correct, but the result is not entered into the table.

Does anybody have the code to do this?

Thanks a lot,
Eric