Code

[crcastilla]

Hello,

I want to put a check box in a form and I want it so I want to check the box it asks me for a password.

How do I do this?

Thank you!

 

[crcastilla]

I meant to say so when I try to check the box it will ask me for the password.

Please help.

 

[crcastilla]

Okay so this is what I typed

Private Sub Sales_Click()
If InputBox("Enter Password Please") <> "somevalue" Then
MsgBox "Password Invalid.", vbOKOnly
Cancel = True
Exit Sub
End If
End Sub

It does ask me for the password but it still lets me check the box. I want so when I want to check the box it will ask me for the password and if I put the wrong password the box will not get checked.

Sorry I did not explain that earlier.

 

[Poppa Smurf]

You could use this

Private Sub Sales_Click()
If InputBox("Enter Password Please") <> "somevalue" Then
     MsgBox "Password Invalid.", vbOKOnly
     Me!sales=false
else
    Me!sales=true
End If
End Sub

 

[crcastilla]

I know this is old but I forgot that I also want it that whenever I try to uncheck the box it will ask me for the same password and I don't put it in correctly then it will not be unchecked.