Password verification

[fabiola1]

I'm using Ms-access 2003.I have a table called users it has two fields called Username and password.I have created a form called security interface.where the user enters the username and password.Can you check the following code.it is not working.I want the code to verify if the entered password and username is correct and open a form or else tell the user to re-enter.

Dim STDOCNAME As String
Dim stuser_login As String
 
    Cmb_User.SetFocus
    Setrs = Me.RecordsetClone = Me![Cmb_User] & "'"
    Me.Bookmark = rs.Bookmark
    Verify = Me.Password
    STDOCNAME = "WELCOME TO CONTRACTS MANEGEMNT SYSTEM"
    DoCmd.OpenForm STDOCNAME, , , stuser_login
 
    If Fld_PASSWORD = Verify Then
        If Fld_Username = Verify Then
 
            If UCase(Fld_Username) = "HENDRINA" Then
                If UCase(Fld_PASSWORD) = "JOD" Then
 
 
                Else
                    MsgBox "Incorrect password"
                End If
            End If
        End If
    End If
 

[MMcCarthy]

OK there are a number of problems which I will try to address
The biggest one is here

     Setrs = Me.RecordsetClone = Me![Cmb_User] & "'"

Setrs doesn't mean anything. However ...

Dim rs as Recordset
 
    Set rs = Me.RecordsetClone

does.

You cannot however then try to set it to Me![Cmb_User] & "'"

Why were you trying to do this?

Also RecordsetClone will take into memory a copy of all records currently bound to the form. I don't think that's what you are trying to do.

Can you explain in plain english what you were trying to do here?