Non Editable Form With List box

[Guest]

I have a form with a list box to find and display info from a table.
I’d like to have the form “not†editable unless a button is clicked to allow
editing. But, I would like to be able to select another record from the list
box to view the data without having to click the "allow edits" button. But,
once one selection is made; I cannot click on anything in the list box until
I click the “allow edits†button. Any suggestions on how to make the fields
in the form “not†editable and leave the list box editable?

 

[Guest]

Rather than set the AllowEdits property of the form to No (False), Set the
Locked property of each control to Yes (True) except for the list box. Then
change the code behind the button to change the Locked property of each
control to False.
You will also want to put code in the form's Current event to lock them for
each record.

 

[Guest]

Thank you, I'll give this a try

Rather than set the AllowEdits property of the form to No (False), Set the
Locked property of each control to Yes (True) except for the list box. Then
change the code behind the button to change the Locked property of each
control to False.
You will also want to put code in the form's Current event to lock them for
each record.