How to connect a table with an interface and validation ?

[sunny1]

Hi,
I have a table called "users", it has six fields "userId" and "password","EmpId" etc.

I have a form called "User Login Form". It has two text boxes and a button as following:

1- txtUsername
2- txtPassword
3- submit
4-cancel
5-reset

I would like to link these textboxes with a table. The idea is that the user must enter his/her userId & password in the mentioned text boxes. Then, the user will press the Submit button.

So the system will varify the input, if it not correct the error message will appear. If it correct, then the required form will be displayed (^_^).

this process is very new for me and I its very urgent for me .I would be more appreciate with your kindly assistance.

thanks...

 

[mikebaldam]

Check out using a recordset.

http://www.everythingaccess.com/tutorials.asp?ID=VBA-Traps:-Working-with-Recordsets