how do i store the result 1

[dywaynewatkins]

Ok, I have a form called CustomerInfo
On this form i have a field which calculates and comes to a total ([ADSCI]+[SalesTax])
The name of this field is called TotalMonthly

Now want i want to do is take this total and store in a table called CustomerInfoTbl
but the problem i run into is for the control source i have this
control source:[ADSCI]+[SalesTax]
Now how do also make the control source tell the field where to store the end result?

When i try to make the control source point to the table that i want it stored in, there is no longer any calculations done
Please Help

 

[WB786]

Here is the best way I have found and works really well.

1. Take your current calculating field and hide it on the form. Create another text box and bound that to your table value you want to store the data into.

2. You will have to put the following code somewhere on your form, no load, or on current, or if a user is typing in a value in another field then on lost focus prehaps:

Me.NotHiddenTextBox.Value = Me.HiddenTextBox.Value

3. You can also set the default of your not hidden value equal to the name of the hidden text box.

WB

 

[gusbrunston]

[tt]
Hi:

Are you sure this is one of the few instances that the rules of normalization should be disregarded?

Just asking. Gus Brunston An old PICKer, using Access2000
[tt]Want solutions you can understand?
Post understandable questions.[/tt]