Hi All.
To delete record on continuous form I created button with code Click event:
When I click button I'm getting error message:
Rune-time error '2046':
The command or action 'DeleteRecord' isn't available now.
on line DoCmd.RunCommand acCmdDeleteRecord.
The property of continuous form Allow Deletions set Yes.
How to fix the problem?
Thanks
To delete record on continuous form I created button with code Click event:
Code:
Private Sub cmdDelDelivery_Click()
If MsgBox("Do you wish to delete this record?", vbYesNo, "Delete Confirmation") = vbYes Then
If MsgBox("Are you SURE you want to delete this record?" & vbCrLf & _
"This will permanently delete the record.", vbYesNo, "2nd Delete Confirmation") = vbYes Then
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdDeleteRecord
Form_fInventory!fReceiveSubForm.Requery
End If
End If
End Sub
Rune-time error '2046':
The command or action 'DeleteRecord' isn't available now.
on line DoCmd.RunCommand acCmdDeleteRecord.
The property of continuous form Allow Deletions set Yes.
How to fix the problem?
Thanks