I am trying to create a form in which three users on one team use, and one user on another team posts questions on. What I want to happen, is that the team of three can only view questions that have their user name in the user field on the form. How do I get the form to open this way for each user? But also, the one posing the questions must be able to view ALL the records.

Basically, this is a form of errors in our system that need to be addressed. Sometimes, there are questions. So someone will ask questions on the errors, and I want to see the questions on the errors I discovered, so that I can personally answer the question, while, let's say "Joe" on my team wants to only see the questions to the errors he discovered, and not see my errors, etc.

Any ideas???

-Beansprout

Is the user name and their "permissions" stored in a table? or are you using the MSAccess workgroup user name? or are you using the Windows NT userid?

Do all users have there own Front End of the application?

It is possible to do.

You have three basic options:

1) Use the Access built-in security

or

2) Create you own security system.

or

3) Check the Windows user name

Then you will have to update the objects to check to see what user is logged in and what permissions to assign.


Edited by: HiTechCoach on Wed May 31 18:53:38 EDT 2006.

I am using the Windows User signon function: Environ("UserName") function. So far, I think it has worked, but the person who needs to open the form isn't here to do so, so I can't test it yet.
Also, so far I can see my errors only, which is a good sign!
-Liz (Beansprout)