Check Box

[Guest]

I have a check box in a form. I want a msg box to pop up everytime it is
clicked on. Asking the user if he/she wants to continue. If user says yes
then the box changes from unchecked to checked or from checked to unchecked.
If user says no then the box stays the same. Im having problems writing the
code for this.
Thanks to those who can help.

 

[Guest]

I hope that my post on the "Forms Coding" will answer your question

http://www.microsoft.com/office/com...ding&mid=932ed400-8131-4252-97bf-82d308c11137

 

[FD]

I have a check box in a form. I want a msg box to pop up everytime it is
clicked on. Asking the user if he/she wants to continue. If user says yes
then the box changes from unchecked to checked or from checked to unchecked.
If user says no then the box stays the same. Im having problems writing the
code for this.
Thanks to those who can help.

Ok Tanhus urs is not a big issue.
on checkbox click write following in VBA code.

Private Sub Check10_Click()
If MsgBox("Yes/No", vbYesNo) = vbYes Then Check10.Value = Not
Check10.Value
End Sub

Good Luck!!