Send a message after a requery using vba

[annmv888]

I have a subform2 on subform1 on the main form. On a currency field curAmount on subform1 I requery subform(2) where I am listing all the curAmount for the year and summing them in a total field sumcurAmount. I have the following code on curAmount AfterUpdate event for the requery. This works fine.

Private Sub curAmountOfCheck_AfterUpdate()
 
If Me.Dirty Then Me.Dirty = False
Forms!frmMembers!subfrmSeries.Form!subfrmReimbursementChecks.Form.Requery
 
End Sub

The problem I cannot resolve is I want to send a message if the sumcurAmount (unbound textbox) field on subform2 has exceeded $150. I have tried to put it on the AfterUpdate event for sumcurAmount because it does update the field due to the requery but nothing happens.

[June7]

AfterUpdate event triggers only when data is changed by user input, not code or calc.

You will have to use the AfterUpdate event of some other control. Why not curAmount? Or is that curAmountOfCheck?