Lock Fields Once Record is Closed

[KSReynolds]

I have several forms in my database that have a closed (1=Closed) option button. Is there a way to make all of the fields for that record readonly if the closed option is set to equal 1?

 

[pbaldy]

One way would be to set the AllowEdits property of the form based on that field. Same concept as here:

http://www.baldyweb.com/ConditionalVisibility.htm

 

[pr2-eugin]

Use the Form Current method.. Use the Option to test and loop through all controls to set Locked property to Yes.

 

[KSReynolds]

That was really easy!