i only found this page today and it has really helped, got a problem, is it possiable to put passwords on command button, so only select few have access to that form, if so it would really help. Thanks

I will have to assume that an "unauthorized" person has no other means to get to the form within the database. (i.e. in database view)

The password can work on the command button, but writing the code to the OnClick to throw up a password form and then check it against the "password" using If-Then code statements. If it matches, open the form, else if - MsgBox "Wrong Password". Go back to other form.

If all users have 'accounts' then you could test to see what person or group is loggged on and allow or deny access that way!

e.g.
if currentuser() = "Admin" then exit sub
if currentuser() = "H" then
docmd.openform "myform"
end if

THANKS FOR THE ADVICE I FOUND THAT SOMEONE AT AN EARLIER STAGE ASKED THE SAME QUESTION AND I USED THAT INFORMATION AND IT WORKS, MY BOSS IS WELL IMPRESSED THANKS

Hi ,

i just wanted to know where was the path or the code for the password on te command button. i just wanted to see if it varies from what i have written.:)

Hello:
Take a look at Candace Tripp's site below. She has an excellent example of how to do this.

http://www.candace-tripp.com/pages/access_downloads.aspx

Regards
Mark

Thanq i got the answe for the site u mentioned. It was of great help:) :p ;)