Hi Guys!

I'm jumped back into developing my database to add a few new features. One of them worked initially but now it doesn't.

It's a delete record button.

YES! I KNOW! Deleting is BAD! As you'll see from the code, its password protected so only I or the boss can use it. He's had "The Talk" and will only be used for bogus entries lol!

Private Sub Button_DeleteRecord_Click()

Dim strInput As String
Dim strMsg As String

Beep
strMsg = "Input Password"
strInput = InputBox(Prompt:=strMsg, Title:="Delete Confirmation")
If strInput = "His Password" Or strInput = "My Password" Then 'password is correct

    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 acCmdDeleteRecord
         MsgBox ("Client Deleted")
    End If

Else 'password is incorrect
MsgBox "Incorrect Password", vbCritical, "Invalid Password"
Exit Sub
End If

End Sub

- Bold is where the Debugger Stops
- Compiler shows no errors, completes fine
- Write access to the backend confirmed ok
- Pic 1 is the error generated in the encrypted FE
- Pic 2 is the error generated in the dev FE

Many thanks for the help