Stop Entry of data once finished

[cterrell16]

I made a purchase order database using the starter solutions but I want to add a function. I want to be able to select a button (like off and on) and stop the editing of the data. This would stop someone from coming back and editing information by mistake. How can I do that?

[Fitch]

The "Security Concepts" forum is a good place to look for ideas. For example:

http://fmforums.com/forum/topic/83510-lock-a-record/#entry386796

[cterrell16]

I've looked that over along with a few others. It doesn't work on our situation because we all have complete access. There must be a better way to lock a record.

[comment]

It doesn't work on our situation because we all have complete access.

If all of you have full access, then all of you can lock a record as well as unlock it. That's fine, if all you want to prevent is accidental editing. In such case, a simple solution could be using a tab control with 2 tabs; one containing fields with no entry allowed in Browse mode, the other containing the same set of fields with the entry enabled.