Hello everybody, what cause of delete confirmation message to appear twice? I'm trying to delete a record from subform of nested forms, but I got Cascade deletion to appear two times when I cancel the deletion, however, it appears once if I confirm the deletion process. Any help please ?
Delete confirmation message firing twice (1 Viewer)
- Thread starter AlefAelol
- Start date
GinaWhipp
AWF VIP
- Local time
- Yesterday, 21:31
- Joined
- Jun 21, 2011
- Messages
- 5,900
One way you can suppress the message...
However, depending on *how* you are deleting the message the above may not work. So, please help us out by posting your deletion code\method.
Code:
DoCmd.SetWarnings False 'Before deletion
...
DoCmd.SetWarnings True 'After deletionHowever, depending on *how* you are deleting the message the above may not work. So, please help us out by posting your deletion code\method.
Thank you for the replay. The deletion done by the delete button of the datasheet form, so no method used. However, I use the code below
Code:
Private Sub Form_BeforeDelConfirm(Cancel As Integer, Response As Integer)
Response = acDataErrContinue
If MsgBox("Are you sure you want to delete", vbOKCancel) = vbCancel Then
Cancel = True
End If
End SubOnce I delete a record, a message of "OK Cancel" as in the code above appears, so if I hit cancel, the same message fires again, but if I hit OK, then the record be deleted and no message appears.
Sorry, it was my mistake, I meant right click + delete record OR select the record and delete by the keyboard delete key.
Last edited:
I just wanted to customize the delete confirmation message to be more readable. Because, the deleted record is marked as "cascade delete related records" so the intrinsic confirmation message would be confused to the user. BUT, even when I delete the VBA code, the intrinsic prompt firing twice.
Sorry, it was my mistake, I meant right click + delete record OR select the record and delete by the keyboard delete key.
I can't reproduce your problem, could you post your database with some sample data, (zip it) + description how you delete the record!
