Dear all,

I am trying to create a login for different users to have access to certain forms in vb6 I have an oracle database which has three different tables for three different user each have a username and password.

the code that is working for one user is below


If rs.EOF <> True Then

If rs!password = Text2.Text Then

Pass = Text2.Text


Unload Me

form1.Show
else
msg


the rs is the select query selecting the username and password from one table where its the username = text1

Hope some1 can help?