Delete Record

[Guest]

I have a form that contains a subform in Datasheet view. The form contains a
"summary" (i.e., min, max, avg) of the records in the subform. When the user
deletes a record in the subform, I need the summaries to update.

I have tried using a recalc of the "mother" form when the OnCurrent event of
the subform occurs, but this causes a loop.

I would rather not use the After Del Confirm event, in case the user has
disabled confirmations of deleted records.

Thanks in advance,
Rob

 

[Lynn Trapp]

See my response to your other post below.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html