Edit Button for Locked Form?

[tanyalee123]

Hello!
The purpose of my database is to enter information from a questionnaire. I have already loaded the personal information of the participants into the database. Because I have loaded it already, I want the fields to be locked so the data entry people don't accidentally type over someone's name, etc. However, I also need them to be able to change the information if it is different on the paper questionnaire.



What is the best method of allowing for edits but keeping the form fields locked initially? I tried to create a button that would open the form to editing (which seems to me would be the easiest thing to do) but when I tried to create a macro for the button, I didn't see an edit choice.

Thank you for any ideas!
Tanya

[mrojas]

I'm sure that there are other ways of achieving this, so here's my suggestion:
Set all fields to .Locked=True
Then for each field add .Locked=False on the DoubleClick event. If there many fields, unlock them in a loop.
This will give the user the ability to unlock only the field that may need editing.

[tanyalee123]

I'm sure that there are other ways of achieving this, so here's my suggestion:
Set all fields to .Locked=True
Then for each field add .Locked=False on the DoubleClick event. If there many fields, unlock them in a loop.
This will give the user the ability to unlock only the field that may need editing.

Hmmmm, I just get an error if I do that. ?? Is this what it should look like? FirstName.Locked=False on the DoubleClick event?

[lfpm062010]

Try

Me.FirstName.Locked = False

[tanyalee123]

Thank you both...I think I was just putting it in the wrong place, but it works. I like this idea because they would only be needing to edit a field here or there, so this is perfect. Thank you!!!

Tanya

[mrojas]

Buttons cannot be locked, only enable or disable and make visible or not.

[mrojas]

If problem is solved, please mark as such.