 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / November 2006locking of a record
In a form view, what is the best approach to locking a record. I'm anticipating having a toggle box that can be selected. I'm new to access so any detail on how to approach this is appreciated. >In a form view, what is the best approach to locking a record. I'm >anticipating having a toggle box that can be selected. > >I'm new to access so any detail on how to approach this is appreciated. Depends on what else is going on in your form. One way is to just set the form's AllowEdits property to True or False.  SignatureMarsh MVP [MS Access] Can I define the "allow edits" as part of a toggle box? > >In a form view, what is the best approach to locking a record. I'm > >anticipating having a toggle box that can be selected. [quoted text clipped - 3 lines] > Depends on what else is going on in your form. One way is > to just set the form's AllowEdits property to True or False. If you want the toggle box to enable and disable editing, then No, you can not. When AllowEdits is False, you will not be able to change the toggle box either. You can use a command button to flip the state of AllowEdits by using a Click event with: Me.AllowEdits = Not Me.AllowEdits If that's not sufficient, please provide more details. SignatureMarsh MVP [MS Access] >Can I define the "allow edits" as part of a toggle box? > [quoted text clipped - 5 lines] >> Depends on what else is going on in your form. One way is >> to just set the form's AllowEdits property to True or False. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.