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.
Code:
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.