MS Access - locking fields in a record

Question

I have a form that displays records, in one field in the record, if it is clicked, i would like to lock the other fields in that record only. How do you do this?

I've put code in, however it locks those fields for every record... I only want it to affect the record that has that check box clicked.

Answer 1

You need to use much the same code for the form's current event procedure as you are presently using for the control's Click event procedure.  But you don't need to assign a Null to the control in this case, so:

If [Required].Value = True Then

    Me.Log.Locked = True

    Me.Log2.Locked = True

    Me.Log3.Locked = True

    Me.Log4.Locked = True

    Me.Log5.Locked = True

    Else

    Me.Log.Locked = False

    Me.Log2.Locked = False

    Me.Log3.Locked = False

    Me.Log4.Locked = False

End If

Is Log5 deliberately excluded from the latter set?  If so including it in the former will keep it locked once it is locked.

In the case of your current code, though, which you also need, I'd use the control's AfterUpdate event procedure rather than its Click event procedure.

---

Ken Sheridan, Stafford, England

Answer 2

Are you using a form in continuous form mode?

---

Hope this helps, Scott<> P.S. Please post a response to let us know whether our answer helped or not. Microsoft Access MVP 2009 Author: Microsoft Office Access 2007 VBA Technical Editor for: Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports and Queries

Answer 3

This is my code: It placed on the Click() of the check box that signals when the other fields get locked or not. 

Right now when the button is clicked, it locks the fields for every record......

Private Sub Required_Click()

If [Required].Value = True Then

    Me.Log.Value = Null

    Me.Log.Locked = True

    Me.Log2.Value = Null

    Me.Log2.Locked = True

    Me.Log3.Value = Null

    Me.Log3.Locked = True

    Me.Log4.Locked = True

    Me.Log5.Value = Null

    Me.Log5.Locked = True

    Else

    Me.Log.Locked = False

    Me.Log2.Locked = False

    Me.Log3.Locked = False

    Me.Log4.Locked = False

End If

End Sub

I tried putting code (below) to unlock them in the Form_current as you suggested, however it just overrode the above code and allows me to edit all the fields.

    Me.Log.Locked = False

    Me.Log2.Locked = False

    Me.Log3.Locked = False

    Me.Log4.Locked = False

    Me.Log5.Locked = False

am I putting the code in the right spot? is this the correct code?

Answer 4

Use the Current event to test the value and unlock as necessary.

--

Arvin Meyer, MCP, MVP

http://www.datastrat.com

http://www.accessmvp.com

http://www.mvps.org/access

Co-author: "Access 2010 Solutions", published by Wiley

---

Arvin Meyer MCP, MVP MS-Access

Answer 5

On Fri, 4 Jun 2010 00:31:35 +0000, barraj75 wrote:

In the Form_Current event write the code to unlock the field.

-Tom.

Microsoft Access MVP

>

>

>I have a form that displays records, in one field in the record, if it is clicked, i would like to lock the other fields in that record only. How do you do this?

>

>I've put code in, however it locks those fields for every record... I only want it to affect the record that has that check box clicked.

---

-Tom. Microsoft Access MVP