Refresh suform after delete

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that contains a subform that is based on a simble query that
keeps a running count and sum of records entered. I want to be able to
refresh this subform after I delete a record. I have the warnings set off
so. I have and event in my afterDelConfirm, and is shows the record count
decrimented by one, but does not decrease the total field by the amount
deleted.

If anyone can tell me why this happens I would greatly appreciate it.
 
In the AfterDelConfirm event procedure:

If Status = acDeleteOk Then
Me.[Sub1].Form.Requery
End If

where Sub1 represents the name of your subform
 
Back
Top