A alex Jan 4, 2004 #1 How Is it possible to prevent a multiple records deletion in a form? Thanks Ale
J John Vinson Jan 4, 2004 #2 How Is it possible to prevent a multiple records deletion in a form? Thanks Ale Click to expand... Put code in the Form's BeforeDeleteConfirm event to check whether the deletion is allowable. For a more detailed answer, please post a more detailed question.
How Is it possible to prevent a multiple records deletion in a form? Thanks Ale Click to expand... Put code in the Form's BeforeDeleteConfirm event to check whether the deletion is allowable. For a more detailed answer, please post a more detailed question.
A Allen Browne Jan 5, 2004 #3 Cancel the form's Delete event if SelHeight indicates more than one row is selected: Private Sub Form_Delete(Cancel As Integer) If Me.SelHeight > 1 Then Cancel = True MsgBox "Multi-row deletion not allowed." End If End Sub
Cancel the form's Delete event if SelHeight indicates more than one row is selected: Private Sub Form_Delete(Cancel As Integer) If Me.SelHeight > 1 Then Cancel = True MsgBox "Multi-row deletion not allowed." End If End Sub