Login Form

[ocp&mcsd]

Dear all,
I have an application includes one table "info" and two forms "frmlogin" & "frmwelcome".
The table "info" contains many columns, two of them are [UserName] and [PassWord]. This table is filled with three records. "frmlogin" form contains two text boxes and one button. I want the user to enter user name and the password in those two text boxes, and when clicking the button, I want the application if that user is registered or no. If yes, he/she will be moved to the "frmwelcom", that display "Welcome [UserName]".

I did it, but I don't know where my error is.

See the attached file.

Sorry for bothering you.

Thanks & Regards

Mark K.

 

[Oldsoftboss]

This should help...

Because you are looking up a text field, you need to structure the DlookUp slightly differently

Dave

 

[ocp&mcsd]

Thank you very much.
It works.