Update calculated field

[deb]

Access 2013
Main form called fReqWBS with a checkbox called SiteinIowa.
Continuous sub form called fReqWBSLabor

Field in sub form called CosEstimate, it is calculated after the Hours field is updated...
Private Sub Hours_Afterupdate()
If Forms!fReqWBS.SiteinIowa =True Then
Me.CostEdtimate = round(Me.hours * Me.RateIowa, 2)
Else
Me.CostEdtimate = round(Me.hours * Me.Rate, 2)
End if
End sub

If users enter data and the CostEdtimate is calculated, it does not update the records if the user checks the SiteinIowa box. How can I get it to update the CostEstimate when the box is checked.?

 

[Joe4]

You could add the same code to the AfterUpdate event of the SiteinIowa checkbox too.

If CostEdtimate a bound field (bound to an underlying table field)? Typically, you do not want to store anything that can be calculated.
Tpyically, I prefer to do all these type of calculations in a calculated field in a query, and then use the Query as the source of my Form.

 

[deb]

You could add the same code to the AfterUpdate event of the SiteinIowa checkbox too.

If CostEdtimate a bound field (bound to an underlying table field)? Typically, you do not want to store anything that can be calculated.
Tpyically, I prefer to do all these type of calculations in a calculated field in a query, and then use the Query as the source of my Form.

Thanks, I wanted it in the table for history purposes, I will go back to the drawing board

 

[Joe4]

Thanks, I wanted it in the table for history purposes, I will go back to the drawing board

That actually is one of the exceptions of when you might actually store calculations, although you may want to also consider just saving the rates (and included dates for when those rates were effective). You will probably end up saving a lot less data if you just store the historical rate table instead of saving everyone's historical calculations.

 

[deb]

I like that idea better. Thanks