Can an individual form in the database be password protected - I know I can split the database into a front and back end?
If you open the form from another form then you can place an unbound text box on the first form and then whether you open the form with a macro or code make it dependent on an entry in the unbound text box such as
[Forms]![Form1]![TextBox]=82356298356 or "whatever"
And it doesn't matter what password you type, it will open the form regardless.
Here is what I have
Two forms Supervisor Main Form and Security Form
The user opens the Security form and there is a command button and an unbound textbox named text1.
I have a macro with the command openform.
It is set to open the Supervisor Main Form Where Condition:
What am I doing wrong or what else do I need to do to make this work?
The best way is to tie up your form security with overall ms access security. If your app is already secure and ppl have to login to use it then all you have to do is create special groups and specific users to those groups. Then in the form just check if the current user belongs to the group that should have access to this form. Thats it !!! can't be easier than that. !!!