John,

I should have thought it better programming practice to change the value of the balance textbox and let the save process change the table's field value when the user chooses to execute it. Anyone else have comments on this?

Diana

>Hi Eric ---
>
>Place the calculation in a custom method in the form, such as CalcBalance. In the LostFocus of each control that could affect the balance do a THISFORM.CalcBalance. In the CalcBalance method, calculate the balance and use REPLACE to store it in the balance field in the table. The balance textbox should have a ControlSource of the balance field. After you have done the REPLACE in the CalcBalance method, refresh the balance textbox (THISFORM.txtBalance.Refresh). Also ensure that the balance textbox is disabled.
>
>
>
>
>>
>>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