Restricting Access via Comand Buttons

[despatcher]

I have created a db and would like to apply the format of the attached zip file

I cannot seem to work out how it was done cutting and pasting the code is not working either if someone could take a look and give me a simple method of creating the desired solution i would be very greatful

The button to access the password will be called DCC Log In.

This will then allow the Command Button DCC to be Clicked (Previously Hidden as in the example)

This opens the DCC Form (already achieved by =openForms("DCC")

 

[KeithG]

Write some code on the buttons click event to make an input box prompting for a password

 

[supercharge]

You don't even need to ask for password or anything, upon loading the form, get the Windows userID and enable the relevant form for that user only. Of course, this is assuming the db is a shared one.