Delete record confirmation msg inhibited when code in OnCurrent?

  • Thread starter Thread starter Darren Evans
  • Start date Start date
D

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.
 
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).
 
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.
 
Back
Top