I have two fields that I am trying to have recalculated any time one or more of three text boxes are updated. Two of the text boxes are numeric and are working correctly. The third is text and does not seem to update. Any reason why? I have tried throwing in a refresh statement as well, with no success.
Private Sub txtPamt1_AfterUpdate()
Run "calc_IntCom1"
Run "calc_RnwCom1"
End Sub
Private Sub txtSA1_AfterUpdate()
Run "calc_IntCom1"
Run "calc_RnwCom1"
End Sub
Private Sub txtInt1_AfterUpdate()
Run "calc_IntCom1"
End Sub
Private Sub txtRnw1_AfterUpdate()
Run "calc_RnwCom1"
End Sub