Before Delete issue

[reglarh]

I have a subform with multiple line entries. When highlighting one entry and pressing 'Delete', Access asks to confirm the deletion. However, the displayed details have been cleared. They are reinstated in the 'No' option is clicked, but how can I stop the displayed data being cleared first. It makes confirming the deletion more difficult since I canot check that the correct entry is being deleted without reinstating it first.

 

[Minty]

That's inbuilt access behaviour, assuming you mean right click and select delete from the options?

The only way around that would be to disable deletions and then code a cmd button to do the delete for you with a coded message box confirmation.

 

[reglarh]

The user uses the delete key, but I am not sure that this difference matters.

Is there no way of redisplaying the missing data before answering the deletion confirmation message?

 

[jdraw]

You may find more info in this post

As Minty suggested, developers often add a command button for Delete (and other actions) then use the click event to perform the logic you want (confirmation before actual deletion).

Additional info here.