Count the number of records deleted and then fire a sub routine

[neuk]

I would like to count the number of records deleted and then fire a sub routine to perform an action based on the count. The problem is that the on delete event fires for each record selected, so I don't have a way of knowing when to fire the routine. I'm in datasheet view and I'd prefer not to change this to a continuous form or write a special delete procedure based on a button.

Initially I thought to create a collection from the on delete event and then pass the collection into the module from the After Del Confirm event. Sadly I noticed the After del confirm event fires before, not after, the on delete event. Any thoughts? I'd just like the ids from the deleted records and fire another routine with that information accessible immediately after.

[Gicu]

Have a look at this thread, it should give you the info you need:
https://stackoverflow.com/questions/...d-from-subform
Please post back with your attempt if you get stuck.
Cheers,
Vlad

[neuk]

Yeah. I was afraid of that...but then the thought occurred to me, why do I even need to make the collection? Why don't I just write a function and loop through the function, with the current value, each time the delete event fires? Brilliant. Seems to work just fine. Thanks Vlad. You're a genius.

[Gicu]

Don't know about that , but glad you solved it!
Cheers,
Vlad