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
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05