cterrell16 Posted June 5, 2012 Share Posted June 5, 2012 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? Link to comment Share on other sites More sharing options...
Fitch Posted June 5, 2012 Share Posted June 5, 2012 The "Security Concepts" forum is a good place to look for ideas. For example: http://fmforums.com/forum/topic/83510-lock-a-record/#entry386796 Link to comment Share on other sites More sharing options...
cterrell16 Posted June 5, 2012 Author Share Posted June 5, 2012 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. Link to comment Share on other sites More sharing options...
comment Posted June 5, 2012 Share Posted June 5, 2012 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4355 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now