Read Only Form / Password to Edit form Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up my database to be able to have a button that when
clicked the user can enter and read the data as "read-only", but I also want
a button that when clicked the user enters an admin password and can then
edit the form.

I have seen how to strickly password protect a form, but not both?

Any ideas ? suggestions?

Thanks in advance..

Brook
 
in design mode, set all the contols' Locked properties to True. Then, when
the click the button to enter a password, pop up a box that gets and verifies
the password. If the user puts in the correct password, change all Locked to
False
 
Thank you for the response...

How do I set up a button for password acceptance? and how do I code the
"set tot true" for all locked fields?

thanks,

Brook
 
put a command button on your form. Create a small modal popup form to accept
and validate the password. Open the form in the Click event of the command
button. Once the password has been validated:
Me.MyTextBox.Locked = False '(allows entry)
 
Back
Top