Password Problem

[razor23]

Hello,

I made a password form and im trying to connect the user name and password text boxes to the contents of a password table. how can i connect it so when i click on the enter button, the program checks the table if the user name or password exists in the table and if it matches.

    Dim stDocName As String
    Dim stLinkCriteria As String
    Dim strUserName As String
    Dim strPassword As String
            
    If UserID.Text = "" Then 'its blank because i dont know how to link it to table yet
        If UserPassword.Text = "" Then 'its blank because i dont know how to link it to table yet
        stDocName = "Main"
        stDocName1 = "Password"
        DoCmd.OpenForm stDocName, , , stLinkCriteria
        DoCmd.Close acForm, stDocName1
        Else
        MsgBox "USER ID AND PASSWORD DOES NOT MATCH!", vbOKOnly, "INVALID PASSWORD"
    End If
    End If

btw when i click on the enter button, a dialog box appears saying "You cant reference a property or method for a control unless the control has the focus"...what does that mean?

 

[qdogfball]

Search out Dlookup and Password on this site

Here is one way..

http://www.access-programmers.co.uk/forums/showthread.php?t=130141&highlight=Dlookup+Password