using password to open form

F

Fred Thomas

Two questions, both have to do with a form that I want to
open only after a password is accepted. The password is
entered into textbox "txtPassword" in form "frmPassword"
the form I wish to open is "frmSecondarys. I assigned the
following code to the txtPassword "On Click" event:

Private Sub txtPassword_Enter()
Dim pass As String
pass = administration
If pass = txtPassword Then
DoCmd.OpenForm "frmSecondarys", , , , acFormEdit
Else: MsgBox "Try again!"
End If
DoCmd.txtPassword.SetFocus
End Sub

Needless to say this does not wrork.
First question what should be here?

Second question, is there a way to hid the password as its
being typed in, saw with asterisks.
Really new to this programming thing. TIA
 
Top