I have a subform which is displayed in continuous form where edits and additions are not allowed but deletions are.
This subform's On_delete event is as follows:
Private Sub Form_Delete(Cancel As Integer)
Dim strText, strAnswer As String
strText = "Are you sure you want to delete '" & Me.FullText & "'?"
strAnswer = MsgBox(strText, vbYesNo)
If strAnswer = vbYes Then
Cancel = False
Cancel = True
The problem (which is only an irritation) is that if the user chooses "no" the mesage box appears again before acting on the response. If they choose "yes" it doesn't. Changing which button has the focus makes no difference. Under 'confirm' on the 'edit/find' tab of 'options' I have "record changes" set to "off" so I cannot see that it is an automated message. Any suggestions as to the reason it does this twice and what I can do about it.