dear all,
i prepared a form for user id..following is the vb command i prepared...
Private Sub LogIn_Click()
If Me.qpwd.Value = DLookup("PWD", "AUTHORIZED", "USERID='" & Me.quserid.Value & "'") Then
DoCmd.OpenForm "form1", acNormal
Else
MsgBox "Invalid Password"
End If
End Sub
where...