Locking(Read Only) Fields

[janet K]

I am sorry if I am not using the correct terminology here. I have a database that we use in our admissions office to track events school visits and information sessions. Once an event has been marked as "display on web" I don't want anyone to be able to change any of the location or date and time information. Can I lock a field so it is read only based on the value of another field? Would I do that with scripts?

Thanks for your time.

Janet

[Vaughan]

Yes you can. It doesn't need to be done with scripts.

Search for form for "record lock" and read up on record level access privileges.

[janet K]

Vaughan..thank you for the response.

I have searched for lock record but I only want to lock certain fields not the entire record.

[TKnTexas]

It might help to know the conditions under which you want to lock them. I had database that 3 days after then end of the month I locked the data. I did so by a date test. If it was past the 3rd day I went to a layout with READ ONLY fields. Otherwise I went to a normal layout.

[awoolway]

If you want to lock specific fields on a layout screen in version 9 goto Format, then Field Behavior. Then simply turn off the "In Browse Mode" checkbox (next to "Allow field to be entered").

I am not sure if this is what you are looking for, but it sounds close.

[Vaughan]

"I only want to lock certain fields not the entire record."

Record-Level Access allows control down to individual fields.

Keep digging.