Unlock field in a form by code

[Todd]

I created a form that people can view to get data from. I
locked the fields so they don't accidently delete or
change the information.

I would like to have a button on the form that will
automatically unlock the fields (that are locked) on the
form (to allow certain users to change or modify the
information) if a username and password is entered.

How can this be done?

Thanks
Todd

 

[Rick B]

Why would you do that? If you have user-level security set up, the user
can sign on when they open the database. Then, you can base your security
settings off that. You might has 'data entry' users who can add records,
but 'data supervisors' who can modify or delete, for example.

Rick B



I created a form that people can view to get data from. I
locked the fields so they don't accidently delete or
change the information.

I would like to have a button on the form that will
automatically unlock the fields (that are locked) on the
form (to allow certain users to change or modify the
information) if a username and password is entered.

How can this be done?

Thanks
Todd