I have a login form that appears when the user opens the database. The user selects his/her name from a combobox (I am using a SELECT stmt for the row source to pull userID, userName, and userAccess from a table) and then enters their password. Next they click an 'enter' button that verifies their username and password as well as their database access rights.
While this verification is taking place I have a splash screen that pops up that shows the progress of the verification.
What I am trying to do.
1. Hide the login form on the same 'enter' button.
2. Reference the username combobox on the hidden form in a text box on the visible splash screen form.
3. Finally, use the information in the hidden form to restrict the users access to certain forms and reports. Essentially what I am looking to do here is place an IF stmt in the form or reports onOpen event that checks the users access code in the hidden frmLogin and if it is corrent THEN open the form IF NOT then display a message stating that they do not have access to this form/report.
I am not trying to implement a security policy. I just want to limit certain forms and reports to individuals that need to access them.
Thanks for the help.
Sean