Hello there , i'm just wondering why my log-in form only works for one user name. i have already built a password table where the fields are username and password . Inputed 5 datas inside . (5 usernames) But whenever i login inside the password form , only one username is recognize. I use this ff. Commands... :(inside cmdOk.Click)

if Adodc1.recordset.fields("user's name") = text and    adodc1.recordset.fields("password")=text2 then
form2.show
me.hide
End if

Hope you guys could help me.... tnx