Form security

[Adriana]

I want to create a form that will only allow certain users to be able to add
users to my form which of course goes into a table. The password can be just
one password for the administrator to use or if it's not too much trouble,
have different passwords for each of these users who are allowed to use this
form. Is there an easy way to accomplish this based on the command button to
open the form?

 

[Chris Reveille]

I have a table with a list of users. Each user has a security levels. What
the user can do on the foem is base on these security levels. This works
fine for me because I need security down to the field level. I hide fields,
control the editing of fields... all based on users security level in the
table. The table is easily updated when a user needs security level changes.