I'm working on several databases that manage user logins via storing the information entered in to the logon form on the "main" form page of my db's. For example:
inUserAccess = DLookup("UserAccess", "tblUsers", "[UserID]=" & txtUser)
inUserName = DLookup("UserName", "tblUsers", "[UserID]="...