[RESOLVED] Help Plz

[Jamie_Garland]

i done the following code but it dosent show the records in the textboxes when found.

Private Sub Command2_Click()
With RS
CN.Execute "Select * FROM users WHERE uname ='" & Text1.Text & "'"
        .Fields("uname") = txtUser.Text
        .Fields("pass") = txtPass.Text
        .Requery
        
    End With
End Sub