Need to display error message for password protected form.
Competent Performer
Windows 8 
Access 2010 32bit
I am using the following code to password protect a form.
Private Sub Form_Open(Cancel As Integer)
Cancel = (InputBox("PassWord?") <> "Oscar")
End Sub
However, I want to be able to display a message when the password is wrong.
I tried a MsgBox, but that displayed even when the password was correct.
I am still trying to learn VBA on my own, but it is going slow.
Please help. Thanks.
VIP
Windows 7 64bit Access 2010 32bit
Need an If Then conditional
If Cancel = True Then MsgBox "something"
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Competent Performer
Windows 8 Access 2010 32bit
That's perfect. Thanks.
Error message to display on entry of duplicate value with two fields as index
Error 2759 - Text Box linked to a combo box query returns error message when I sort on a split form
Posting Permissions
Reply With Quote