I have a main menu form. On that main menu form are several command buttons that have a tag of "Secure". If the user clicks on one of the buttons that is set to open a "Secure" form, I want a password form to open and have the user enter a password. If the password equals DLookup("[dbPassword]", "tblSetup") then let them proceed.
If the password they enter does not equal the DLookup, present a message form and Do NOT let them in.
How can I do this from the onclick event of the form? Or if it can't be done this way, how?