Recent content by FunkyMonk150

Hi, I have this so far but it doesnt seem to be working, have i done it right? If txtThePassword = DLookup("Password", "Logon Table", _ "[Username]=" & "User ID") Then usrForm = DLookup("[User Access Level]", "[Logon Table]", "[Username] ='" & "User ID" & "'")...

Hi, Im currently working on creating a user login page in access which i have got working. I now need to make it be able to check the username against its user access level in the table so that the correct main form can be opened. I have done it before but have since forgotten how to do it...