login screen

[shrive22]

I have a login screen where a user enters a 3 digit number in a text box and then clicks login button. after they click login button I want to check the number they typed in against valid employee numbers in my employee table to see if they can login. Does anyone know if this is possible? i think it might involve a sql statement but im not sure.

Thanks for the help

 

[shrive22]

This is what I have so far but it does not work:

Private Sub logincmd_Click()
usertxt.SetFocus

If usertxt.Text = "Select Emp_no From Employee Where Emp_no = " & usertxt.Text Then
On Error GoTo err_cust_click
Dim strdocname As String
Dim strlinkcriteria As String

X = usertxt.Text
strdocname = "DocsDue"
DoCmd.OpenForm strdocname, , , strlinkcriteria

Exit_cust_click:
Exit Sub
err_cust_click:
MsgBox Err.Description
Resume Exit_cust_click
ElseIf usertxt.Text = "" Then
MsgBox "Please enter a valid user name.", vbOKOnly, "Login Error"
End If


End Sub