I have a module that strips the userid from the computer, and I would like
that once it has been stripped, to run an if statement that if userid = ''
then docmd.openform. For the userid equals statement, I would like for it to
call a table that has all Managers on it, or a table that has the auditors on
it, and have a checkbox that makes specifies which auditors are managers to
give them access to a specified form.

What I do is to load all the users in a table with thier name and windows
login.  I also include additional fields for things like email address and
what forms they are allowed to open and other detailed security that Access
can not handle.  I use dlookup on the main form based on their userid.  I
hide these additional fileds.  In your case you would have a field for which
forms an auditor can access.  If that field is checked then you allow the
forms to be opened.  If not the a message is displayed stating why the form
cannot be opened.  What I do is hide the open form button if the person does
not have auditor permissions.
Show quoteHide quote

More ULS Problems
Encrypt Databse Problem
Shortcut target path
Getting round security warnings for task scheduler
Securing an Access Database