Solved Confirmation message when Tick the Check box

[khodor]

Hi Everybody
As you know, Ticking the Check box is too easy and it might be done by mistake
Can I add Confirmation message when Tick the Check box?

 

[mike60smart]

Hi

In the after Update of the Checkbox you need Code like this:-
Private Sub Action_Plan_AfterUpdate() If Me.Action_Plan = -1 Then MsgBox "Plan now Positive" End If End Sub

 

[bob fitz]

You could use the Before Update event of the checkbox. Something like:

    If MsgBox("Confirm Your Action", vbExclamation + vbOKCancel, "Confirmation Required") = vbCancel Then
        Cancel = True
    End If

 

[khodor]

Thanks a lot
this is what I was searching for

 

[bob fitz]

Thanks a lot
this is what I was searching for

You're welcome. Glad we could help