Re-calculate after data is changed

[brbarto]

I have a form where the user enters BeginMileage and
EndMileage. After the EndMileage is entered, the
difference is calculated and entered in a subform control.
How should I handle the fact that the user may change the
BeginMileage. In other words, if the BeginMileage is
changed, I need the difference calculated again.

Thanks,
New to Access

 

[MangroBongacello]

In the after update event of the BeginMileage insert code like this (change the names of controls appropriatelly)

Me!SubFormControlName.Form!CalculatedControlName = EndMileage - BeginMileage

Hope it helps.