Making a Record or Field Read Only depending on another fields contents

[Jed69]

I have a layout which sends an e mail. Once an e mail has been sent it ticks a field in the record to mark it as sent. Is there a way to make this record (or if necessarily each individual field)read only if this box is ticked when this e mail is viewed for information, similarly to the way conditional formatting works.

Many thanks

John

[dreamingmind]

You could set the field to activate a script. The script says:

If test field is empty, go to the field you clicked on.

End If

In the case where the test field has content, the script will run, capturing your click and the field will not receive the cursor.

Regards,

Don Drake

[comment]

Adjust the users' privileges set so that records in this table can be edited only when the condition is met.

[Jed69]

Thank you worked beautifully