At the simplest level, you can code a form's Open
eventhandler to ask a user to input the password and to
cancel the operation if the wrong password is submitted.
If you have a number of forms that need to be protected,
you should look at Tools->Security-> User and Group
Permissions facilities.
Private Sub Form_Open(Cancel As Integer)
Const strFormPassword As String = "Password"
If InputBox("Please Enter Password") <> strFormPassword Then
MsgBox "Password Incorrect", vbOKOnly
Cancel = True
End If
End Sub
You had best read up on Access security as, unless you take
measures to protect the form and its code, it would not
take too much effort for anybody to see what the password was.