Make Fields Read Only After Update is Made to Another Field

[JMB]

When a field is updated with a value of "approved" can that field become
"read-only" as well as other subsequent fields, so that users cannot change
the values once they have been approved?

For example: A status field is set to Approved (from a drop down list)
after the estimated hours have been filled in 4 other fields. I need the
status field as well as the estimated hours fields to become locked or read
only so users cannot change the values.

I do not know SQL, so will need precise instructions on how to accomplish
this.
THANKS!!

 

[Jim Bunton]

how about form oncurrent > form property becomes readonly (alow edits =
false) if field whatever = "approved"

could create some problems if someone says it's approved when they shoudn't
have!!! maybe you'll have to invent some user types with one who can
override this!

 

[JMB]

So on the form properties I would create an event procedure with your
statement in it? Is that correct?

The problem is, I want to lock the status field when it is set to Approved
and then set 4 other fields to lock (read only) too. How would I expand on
your statement to only include those 4 fields and the status field to be
locked?

(Allow edits = false) if Status = "Approved"

 

[JMB]

I tried several versions of your statement on the field properties of the
field itself and nothing seems to work. I can't insert your statement on the
form (oncurrent property) because there are other fields on the form that
need to remain open for data entry.

The "Status" field needs to become read only when the value for that field
is set to "Approved" and four other fields need to become ready only at the
same time.

Any other ideas?

Thanks!!