Delete record confirmation msg inhibited when code in OnCurrent?

[Darren Evans]

MS Access 2000 appears to inhibit the
delete record confirmation message when
code is inserted into the OnCurrent
form event. This happens irrespective
of Tools / Options / Edit/Find / Confirm
tick boxes, or the SetWarnings status.

Is this behaviour –

- a bug? If so, what MS Knowledge
Base article(s) refer to it?
- intentional? If so, where is it
documented in help/manuals?

Thank you.

 

[Van T. Dinh]

The question is why you need the Delete Record Confirmation Message in the
Form_Current Event.

This event fires when the Form moves to a new Current Record so you don't
normally delete Record in this event (since if you delete the Current Record
you trigger another Current Event which can create an infinite loop).

 

[Darren Evans]

Thank you for your reply.
I am using the code in OnCurrent to do something
totally unrelated to deleting records. As soon as
I do this, Access stops displaying the delete
record confirmation message whenever a record
is deleted manually using Edit/Delete Record
menu item or 'Del' key.