Question

[NewPCConsultant]

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.

 

[Chris Reveille]

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.