 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / May 2008How selectively lock records from editing?
In my case, I have a form with a subform. The subform was populated by a query. User should be able to view and enter new records but should not be able to edit existing records. Each record has several fields; the important one is [Rate] and [Type]. If data is entered in [Rate] and [Type] then that record or these two fields should be locked for editing. I tried to do something like this… I did this by adding VB code to the LostFocus() event of [Type] field. Private Sub Charge_Type_LostFocus() If Not IsNull(Me.Rate) and Not isNull(me.Type) Then Me.Rate.Enabled = False Me.Type.Enabled = False End If End Sub As you can expect, this will lock all the record in the list including the ability to enter new records from the bottom of the list. Id there any relatively simple way to handle this? That's what else is for, and I'd use it in the form's Current event: Private Sub Form_Current() If Not IsNull(Me.Rate) and Not IsNull(Me.Type) Then Me.Rate.Enabled = False Me.Type.Enabled = False Else Me.Rate.Enabled = True Me.Type.Enabled = True End If End Sub  SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com > In my case, I have a form with a subform. The subform was populated by a > query. User should be able to view and enter new records but should not be [quoted text clipped - 17 lines] > ability to enter new records from the bottom of the list. Id there any > relatively simple way to handle this? Arvin thank you for you response, however still dosent work. All the records are locked and when I try to add a new record I can not click on the Rate field in order to start to create a new record. When a click on a different filed of the same raw then all the records are unlocked even though the re-lock if I try to make modifications. Any idea? > That's what else is for, and I'd use it in the form's Current event: > [quoted text clipped - 28 lines] > > ability to enter new records from the bottom of the list. Id there any > > relatively simple way to handle this? I may not have understood. To lock existing records, you can adjust the form's property sheet. On the property sheet data tab turn off Allow Editing and Allow Deletions, and leave Allow Additions on. No code at all. Existing records cannot be edited or deleted, and new ones can be added. SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com > Arvin thank you for you response, however still dosent work. All the > records [quoted text clipped - 39 lines] >> > ability to enter new records from the bottom of the list. Id there any >> > relatively simple way to handle this? Jan Baird is out of the country until September 20. Every effort will be made to respond to messages, but please be patient. Jan Baird is out of the country until September 20. Every effort will be made to respond to messages, but please be patient. |
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.