this is my from confirm for user.
Private Sub Command123_Click()
Dim Msg As String
Dim Style As String
Msg = "Are you sure you want to delete this record?"
Style = vbYesNo + vbQuestion + vbDefaultButton2
Response = MsgBox(Msg, Style, "Film Rental Database")
If Response = vbYes Then...