Delete Record Event

[FBxiii]

Hi. I want to run a function when a user deletes a record from a continuous
form.

The event doesnt work in the Delete event as I need to run the function
after the record has gone. The AfterDelConfirm event doesnt seem to work as
I the DB set up to not ask for confirmation of deletion.

Which event should I use or am I not using the Delete event correctly?

Cheers,
Steve.

 

[Alex Dybenko]

Hi,
I think AfterDelConfirm Event is what you need, you have to check if Status
= acDeleteOK, so record was really deleted, and then run your functions

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[FBxiii]

The problem is, the AfterDelConfirm event is not running as I have Record
change confirmations turned off.

Is there a way to 'fool' access into thinking I have confirmed the deletion?

I tried acDeleteOK = True but I just got an error.

Ive also tried Me.Dirty = False in the Delete event but the recordset doesnt
seem to get saved.

 

[Alex Dybenko]

Hi,
I would try to switch confirmations ON, then use BeforeDelConfirm event and
set there:
Response =acDataErrContinue

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com