Search results

I appreciate all your help, but if I can ask this, what event would I use for this? My main goal is to have the database field update on the fly as the form total field is updated.

Your are correct, that the txtReimburseTotal as well as the other fields referred in the expression are not save but calculated on the form. That is why I was trying to move the calculated GrantTotal if you will into the database field.

If you wouldn't store it, how would you save the value to use on like summary reports later on?

I tried to create a macro but there is not a SetValue option. I did it with an expression but it does not update if I change values.

Using Access 2007, I have a form with a unbound control that uses an expression to calculate a total: =[TxtReimburseTotal]+[txtElectTotal]+[txtEducationTotal]+[txtTravelTotal]+[txtMiscTotal] as the control source. I need to take this value and update a bound textbox which controlsource is set to...