Login form macro issue

[neiljames92]

I had it working and must have changed something by accident.. typical.

Can anyone help me on why this isn't working?

h t t p:// puu.sh/5pvkQ.png

Thanks in advance

 

[Drunkenneo]

Does it log in when you supply incorrect Password?

 

[neiljames92]

It doesn't show the incorrect password message or close the window and open my main form if the given password is wrong or right, it does literally nothing!

Does this mean that there is an issue with my Dlookup seen as the step after it isn't working?

 

[David R]

Do any of your other buttons/code work? Have you upgraded Access/switched computers recently? Sometimes Office's paranoid 'security' will lock out VBA until you reset your Trust Center options.

Also check and make sure all of the Event triggers still have the code associated properly. If you rename a control it can lose track of the code sometimes.

 

[lovemeall143]

Im having problem with my macro in log in form. Whenever I put password on it,its either right or wrong password it proceed with my Home Form.My DlookUp is like this

DLookUp("[UserID]","tblUsers","Password=' " & [txtPassword] & " ' ")

What should I do?

 

[lovemeall143]

Here's my sample database that I'm working with.