I’ve got an Access Form with about 10 text boxes containing numbers that add up to a total value held in an 11th text box. I then need to check the value in textbox11 to make sure it doesnt exceed another value (held in box 12).
I’ve attached code to each of the 10 text boxes to update the total in 11, but there must have been an easier way than this:
Private Sub txtInitialDrop1_Vol_AfterUpdate()
Call fCheckInitialVolume
End Sub
Private Sub txtInitialDrop2_Vol_AfterUpdate()
Call fCheckInitialVolume
End Sub
Private Sub txtInitialDrop3_Vol_AfterUpdate()
Call fCheckInitialVolume
End Sub
Private Sub txtInitialDrop4_Vol_AfterUpdate()
Call fCheckInitialVolume
End Sub
etc etc
Is there a way I can use just one _AfterUpdate event, by referencing all 10 text boxes as some sort of Collection maybe?
cheers