Lock down fields

[Guest]

Hi All,

I have a database setup with a form with 2 subforms within it. In the main
form I have a combo box called Status. When the user selects the status of
"Paid" I would like all the other fields in my form to become locked and
therefore not allowing any changes to these fields. Is this possible to do.
I'm sure it is, though I am new to Access and not sure how to go about it.

Thanks in advance
Janine

 

[Allen Browne]

Use the Current event of the form to set the Locked property of the controls
based on the value of your Status field.