Thank you so much for your sample database. The LogOnSample database is something I was looking for. I managed to get it to work with no issues.
One thing that does bother me is that when I click the Staff Name combo box, I can see everyone's logon name, password, and access level. Does this mean my employees can see everyone's username and password?
After I modified the query builder to uncheck "show" for the password and access level, I would get the msgbox "Please check your password. As the one you entered will not give you access."
Is there any other options to get this to be "invisible" and only show the logon name?
Thanks!
Amber
Access 2010
newbie