Password for Form

[rgsw]

Hi-
Is it possible to create a password for individual form in database? If so, how?
Thanks

[MMcCarthy]

In the Form Load event ask user to enter password.

Dim myPassword as String
Dim userEntry as String

myPassword = "AnyTextVau e" ' set this to the password you want
userEntry = InputBox("Enter Password:")

If Trim(userEntry) <> mypassword Then
DoCmd.Close
End if

This is a simple workaround if you need something more secure go to the following msdn site.

http://support.microsoft.com/kb/209871/en-us

Hi-
Is it possible to create a password for individual form in database? If so, how?
Thanks

[rgsw]

In the Form Load event ask user to enter password.

Dim myPassword as String
Dim userEntry as String

myPassword = "AnyTextVau e" ' set this to the password you want
userEntry = InputBox("Enter Password:")

If Trim(userEntry) <> mypassword Then
DoCmd.Close
End if

This is a simple workaround if you need something more secure go to the following msdn site.

http://support.microsoft.com/kb/209871/en-us

That work, thanks again.