I have a form in DataSheet View. I want to click on the checkbox to delete a record. When I first open the form and click on the checkbox, a message pops up saying "You are about to Delete 0 Record(s)". When I click off the checbox then the pop up says "You are about to Delete 1 Record(s)". When I click ok it shows #Deleted in the textboxes. I am not sure why I have to click off the checkbox to delete the record.
Private Sub DeleteRecord_Click()
DoCmd.RunSQL "Delete * From Data WHERE chkBox = True;"