June 5, 201213 yr 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?
June 5, 201213 yr The "Security Concepts" forum is a good place to look for ideas. For example: http://fmforums.com/forum/topic/83510-lock-a-record/#entry386796
June 5, 201213 yr Author 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.
June 5, 201213 yr 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.
Create an account or sign in to comment