PW protecting a single form

[SamL]

Hi, how do I require the user to enter a pw for a single form? All users of the database are entered into a table called tblProviders. There is a Boolean field in the table called Management. The users who have that field checked off may use the form called frmMgmtUseOnly by entering their initials. How do I get this this to be a reality? I have some code, but it's in the switchboard calling the form, and the users could get around the protection simply by opening the form in the side menu. This means that I have to have the code in the Open or Load event of the form itself. How do I do this?



Thanks,
Sam

[Gicu]

The Open event can be canceled so use that event. You should simply do a dLooput to see if the current user is a manager (the boolean field is True) then use an input box to prompt for the password. Finally compare the entered value with the expected one and if different cancel the open event (

Cancel=True

).
Cheers,

[Micron]

Users should not be able to access the navigation pane. Perhaps research how to secure an Access db (as much as that is possible). IMO your users table should have a field for user type, not a boolean for management only, then you would not be restricted to only 2 levels should you need more in the future. For forms that are restricted to a particular level, you can DLookup their level during form open event and cancel opening as mentioned. In fact, the form you open could prevent the ability to launch this form entirely, by restricting access to whatever it is you're using to do that (e.g. command buttons disabled or invisible).

[SamL]

Great idea. Thanks.

Sam