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?
????
But this can get complicated depending on what you need, ...so this might be better dealt with in a separate, new question.
JeffCoachman