password protection

[vicktown2]

How can i password protect certain forms in a database without placing a password for the entire database?

 

[LJtechnical]

Hi

I would use a the following in the on click event of the button that launches the forms you want to protect.


Dim strPword As String
Dim stDocName As String
stDocName = "Form Name"
strPword = InputBox("Enter Password", "Edit Locked")
If strPword = "" Then
GoTo Exit_command name
End If
If strPword = "your password" Then
DoCmd.OpenForm stDocName, , , ,
End If

Hope it helps

 

[randy700]

However, rather than using an input box, I'd create a small popup form because, with an input box, you cannot format the text to display the password character (*).

Randy