How do I get a Access VBA Yes/No message box to either apply/don't apply
Posted on 2014-02-12
I have a checkbox which I would like to have a "Are you sure you want to make this change?" prompt with a Yes and No button. If they clicked yes, obviously the change would apply. If they click no, I would like the the dialog box to exit without any change to the check box.
The VBA code I have tied to the BeforeUpdate field of this check box is:
Private Sub Inactive_BeforeUpdate(Cancel As Integer)
Dim Response As Integer
Response = MsgBox("Do you want to change the status of this client?", vbYesNo + vbQuestion, "Client Prompt")
If Response = vbYes Then
MsgBox "The user status has been changed", vbOKOnly, "Confirmation..."
MsgBox "The user status has NOT been changed"
I'm no programmer but have tried various code formats based on web research but none are fixing my problem.