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

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.

Vaughan..thank you for the response.

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

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.

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.

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

Record-Level Access allows control down to individual fields.

Keep digging.