QUick one Please (1 Viewer)

I have table of Users and Passwords I put in. What I want to do is load the record set of the table. which I have done:-

Private Sub Form_Open(Cancel As Integer)
Dim db As DAO.Database
Dim rst As DAO.Recordset
Set db = CurrentDb
Set rst = db.OpenRecordset("tblFeeEarner")
Do While Not (rst.EOF)
rst.MoveNext
Loop

and then get the person to type is name in the form say in txt1 and Password in txt2 then cheque that both are in the Record set and that the txt1 and txt2 are on the same row of course.

Do you want to verify user name and password before this form opens, and cancel the event if there is an invalid entry?

You may find it easier to use DLookup to check users and passwords in a table.

The form Opens
The user inputs there username and password
this is checked against hte recordset of tblFeeEarners
Then if correct the frmMenu Opens if not then a message is displayed and the user gets another 2 attempts if this is still not correct the recordset is set to nothing and the database closes

search here for password, there have been numerous examples