Calculations too slow

[Randy]

Access 2000. I have a form with a subform. I have a txtbox on my main form
which has the following expression: =[Accountsubform].Form!SumFee I
also have in my before update and on exit event the following code, which
works fine as long as the data entry user works slowly. The problem is that
that the before update code is frequently bypassed prior to the calculation
actually updating. You may get to the next one or two fields before the
calculation is updated. Any ideas?...Randy

Private Sub TotalFee_AfterUpdate()
'If Accountsubform.Form!SumFee <> [Debit] Then
'If MsgBox("Total Fee's Do Not Agree. Review Fee's and make
necessary correction", vbYes + vbDefaultButton2) <> vbYes Then
'Cancel = True
'Me.Form![Debit].SetFocus
'End If
'End If
End Sub