Question Concerning Switchboards

[nobbie1]

Does anyone know if it's possible to password protect certain forms from a switchboard?

I have a database which technicians will enter in data about their line.

I'd also like on that same switchboard an option for the supervisors to enter in data for say a new technician when hired or to be able to view information about a certain tech. I only want the supervisors to be able to have access to this and not the normal technicians.

Is it possible to do this?

Thanks in advance

 

[llkhoutx]

You can use the user's LogIn Name to enable/disable various controls (buttons). The "CurrentUser" function will give you the name to test, e.g.

On form_Open event
dim sLogin as string
sLogin = CurrentUser
select case sLogin
Case "JDoe"
Me!Button1.enabled=true
me!Button2.enabled=False
case "JRose"
etc.
end select


Access Security also can accomplish same, but is amore complicated.