Editing Fields in a Form when the form Doesn't allow edits

[mehgan]

I have developed my form to not allow edits for fear of accidents occurring and vital data being lost. BUT when the time comes some of my fields will need to be edited. I have developed an "EDIT" command, but need to know the how to write the expressions so that when the edit button is hit, a field CAN be edited and saved without leaving the Form Design to allow edits...can anyone help?

Thanks

 

[bustell]

To allow edits to any field on the form you will have to set AllowEdits to True.

The better way to do it, is to set the Locked property to True for all the fields on the Form. This will prevent someone from changing the value.

Then behind the Edit Button, you can change the Locked Property to false for only those fields you wish to be edited.

When you are done editing, you can then relock those controls that you unlocked.

You may also want to change the background color of the controls that you are allowing edits to so that the user knows what controls they can edit.

Another way would be to set the Enabled Property of the controls to False. This also locks out changes to a control.
Pat B