How do I prevent additional data entry?

[dmurnane]

I have a database that is used to monitor maintenance callouts to various buildings, these records are classified as either 'open', 'pending' or 'closed' from a drop down field menu. When the field is changed to 'closed' how can I prevent all the rest of the data in the record from being modified?

Many Thanks,

Dominic

[IdealData]

Have a look at PRIVILEGES, in particular the CUSTOM RECORD PRIVILEGES.

Here you can set the condition to permit editing of a record based on a calculation, in your instance edit would be permitted when

yourfield <> "closed"