Hello people i've got a prob with my code you see im making a login but the thing is i've got my data base and in their i have my UserName fields and password fields yea and my controls on my visual basic are connected to the fields in my data base yea but when i come to code it and everything when i go if txtpass.text = adofirewall.recordesource!Password then
mshbox "yes"
else
msgobox "no"
end if
i get an error saying Qualifer must be collection ???? what i dont understand
and even when i change it to Recordset!Password it just keeps saying yes all the time even when i check the data base its stupid i just need it to work for the user name and password its been doing ma head in now for like 3 months nothing please help me

Please post the code that you are using.

here is the source code

If txtpass.Text = adofirewall.Recordset!Password Then
MsgBox "password correct"
Else
MsgBox "you are denied"
End If
End Sub

hope u can help me

IS SOME ONE GOING TO HELP ME THEN