Ms Access Login form and User Level

Question

I am trying to make Login Form Using DCount and LookUp functions 

My table has the following field LoginID, UserName, Password, Level and Description

Form has:

Combobox Named: "txtUser" bound column is 1 (LoginID) and I hide it by sitting Column Widths by 0

TextBox Named "txtPass"

Login Button and I use If function with AND but it does not work, access alway open the main form to me he did not use "else"

1. I want to say If txtUser and txtPass Mach then, show me message said Successfully, Close Login Form, Open the Main Form, else show me message said Failed, but access does not match "AND" he always open the Main form even If I put wrong password

If

I did this DCount("LoginID","LoginT","UserName=[txtUser]" And "Password=[txtPass]")

I did this DCount("LoginID","LoginT","UserNamer=[txtPass]") And ("Password","LoginT","Password=[txtPass]")

I did this DCount("LoginID","LoginT","UserNamer=[txtPass]" And "Password","LoginT","Password=[txtPass]")

I did this DCount("Password","LoginT","Password=[txtPass]")

they did not work

2. How can I add Level deal with Levels by LookUp?

if the txtUser and txtPass Mach and his Level is 1 as admin open the Main form as edit, else as Read only

Answer 1

Can you see the problem?

No double-quote after the username. Add it, using the same syntax as already shown to you.

Answer 2

Can you see the problem?

No double-quote after the username. Add it, using the same syntax as already shown to you.

I did I past the same code in Macro, I got same problem that I post it before

 DCount("LoginID","LoginT","[UserName]=""" & [txtUser] & " AND [Password]=""" & [txtPass] & """")

plz help

Answer 3

Try

DCount("LoginID","LoginT","[UserName]='" & [txtUser] & "' AND [Password]='" & [txtPass] & "'")

Answer 4

Now if Chose User 1 and his password I got this message box, it did not pass throw 

Answer 5

I see you should want to build a multi-user application because of needing a login form.

According to the restrict of VBA and depends on macro,it looks not flexible and uneasy.

So , if possible,web architecture( like asp+mdb ) is not a bad choice.