Refresh suform after delete

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.
 
A

Allen Browne

In the AfterDelConfirm event procedure:

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

where Sub1 represents the name of your subform
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record insert/delete anomaly 0
Refresh parent form when subform deletes records 1
Capturing delete on Cascading Delete 6
Running code after record is deleted 2
Capturing delete on Cascading Delete 1
Requery/refresh 2
BeforeDelConfirm and AfterDelConfirm not running 2
auto deleting records that are missing data 5

Top