I have this error of 2110 that comes up under the lstAccounts.Setfocus. Im trying to figure out why this is happening. Am i missing something or should I remove something. There is a lstemployees that has some names, but I have a delete button that should remove the name in the listbox but it is not deleteing anything and is coming up with the erro 2110.
Private Sub cmdDelete_Click()
If MsgBox("Are You Sure you want to delete the Employee?", vbOKCancel + vbInformation) <> vbOK Then
CurrentDb.Execute ("Delete * From Employees where EmployeeID=" & Me.txtID)
cmdClear.Enabled = False