I am building a personnal database, the manager wants to be able to let his secertary to enter holidays & sicks days taken by the staff but does not want her to be able to see all the personal details.
Is there a way to password different forms, so when a user enters a password to open the database they are restricted to what they can see.
I have looked a users & groups but that restricts all forms and not just certains ones

Why not have a seperate form for holidays and sick so she can add data and have this protection password on other forms.

Ian


Private Sub Form_Load()
Dim FormPassWord As String
FormPassWord = InputBox("Enter Password", "Password Protected
Entry")
If FormPassWord = "PICK A PASSWORD FOR HERE" Then
Exit Sub
Else
MsgBox "Incorrect password", vbCritical, "SORRY CHARLIE!"
DoCmd.RunCommand acCmdCloseWindow


End If

End Sub

[This message has been edited by ian_ok (edited 11-13-2001).]