password program

I have two or three buttons that are set up on the main menu so when the
command button is pressed it brings up my password form.

What I need to know is do I have to create a separate password form for each
of the two or three forms or can I use one password form for all of them then
have the corresponding program load.

Ex:
Menu command button 1 -> Password form -> Load {docmd.form test1}
Menu command button 2 -> Password form -> Load {docmd.form test2}
Menu command button 3 -> Password form -> Load {docmd.form test3}

Same password form loads 1 of the three programs based on the Menu command
button.

I hope I've explained it right.

Thanks for reading my post

You can certainly reuse the same form. However, keep in mind that there are
ways that a user can bypass the form that you've designed and access the
underlying forms directly. You also have to keep in mind that anything
password-based has to factor in a means to easily change the password should
it become widely known - which if everyone or most everyone knows the
password to begin with, the point of requiring a password is defeated.

Access security supports object-based access which means that you can set
permissions to any particular object on a user or group level. I'd look into
that first before moving forward as Access security will lock things down
much tighter than you could ever code - not to mention its just a matter of
setting it up. Google ACCESS SECURITY and you'll be able to find information
from Microsoft on how to implement it.

"Afrosheen" wrote:

> I have two or three buttons that are set up on the main menu so when the
> command button is pressed it brings up my password form.
>
> What I need to know is do I have to create a separate password form for each
> of the two or three forms or can I use one password form for all of them then
> have the corresponding program load.
>
> Ex:
> Menu command button 1 -> Password form -> Load {docmd.form test1}
> Menu command button 2 -> Password form -> Load {docmd.form test2}
> Menu command button 3 -> Password form -> Load {docmd.form test3}
>
> Same password form loads 1 of the three programs based on the Menu command
> button.
>
> I hope I've explained it right.
>
> Thanks for reading my post