Delete record command

[Kate Cz via AccessMonster.com]

Hello, this is just a user ease problem, not life or death, but here it is:

I have a command button on my form to delete a record.
Access brings up a warning asking the user if he really wants to delete the
record yes or no.
The problem is, when the access warning comes up, the form automatically
moves to the next record, so when the user is reading the warning, he is
seeing the next record, not the record to be deleted, and might get confused.

If the user selects no on the warning, the form goes back to the "to be
potentially deleted" record. If he picks yes on the warning, the record is
deleted, and the form stays on the "next" record.

Any ideas??

Greatly appreciated~~

 

[Dale Fye]

Kate,

Can you post the code behind the button?

Dale

 

[Kate Cz via AccessMonster.com]

Kate,

Can you post the code behind the button?

Dale

Hi Dale,

Here is code behind the button:

Private Sub Command105_Click()

On Error GoTo Command105_Err

RunCommand acCmdDeleteRecord

Command105_Exit:
Exit Sub
Command105_Err:
MsgBox "The Delete action has been cancelled."
Resume Command105_Exit
End Sub

Any thoughts? Much appreciated~

 

[Kate Cz via AccessMonster.com]

This question is answered in the 9/29/05 "Delete Button shows previous record
before current record is deleted" posting.