Hello. I have a listbox and a delete button. Records are being displayed in the listbox using three columns. The first column, TrackID is the primary key for the record. i want the user to be able to click the delete button, have a msg window popup and confirm the deletion, and then delete the record if the user clicks yes. my problem is that the record is not deleting, here is my code (History is the listbox): If MsgBox("Are you sure you wish to delete this ticket?", vbExclamation + vbYesNo + vbDefaultButton2, "Confirm Record Deletion") = vbYes Then DoCmd.SetWarnings False DoCmd.RunSQL "DELETE FROM [Equipment Tracking Log] WHERE [Equipment Tracking Log].EquipNumber = '" & Me.History.Value & "'" DoCmd.SetWarnings True End If Any help would be appreciated.