Password to Open Form

[pmbryant]

Can anyone help me with the following

I have created a button on the main form, that when you click it, another form will open prompting you to enter a password and if correct,that'll let you into the admin form.

The problem is, the macro that i have setup with the password conditions, will only let the password be incorrect once and lets them in if the password is incorrect the second time.

This is what i have in the macro

CONDITION: ACTION
[pw]<>[enteredpassword] msgbox
stopmacro
IsNull([enteredpassword] msgbox
stopmacro
openform


I hope that all makes sense to someone. thanx in advance

 

[braindead2]

I recommend you use VBA but for a macro I suggest

[pw]=[enteredpassword]OpenForm
... stopmacro
msgbox
stopmacro