Records can only be all locked or all unlocked.  To disable editing for certain records, you need to design the form differently.  One way is to lock all records (AllowEdits set to false), put an Edit button on the form's header, and use form's Current event to enable or disable the button.  You can use any logic you want to do that.  For instance, if the record is too old, disable the Edit button, so the user can't edit the record.  Of course, you need a separate data entry form to open when the Edit button is clicked.

What determines whether a Record should be locked or not?

What is the VBS code to lock a SPECIFIC RECORD, not a table, or field or database, a single record in a table.

> What determines whether a record should be locked?

I am  a pilot training center and building  my database for electronic student records. The FAA requires are completing a training record, the record must be locked so it cannot be altered. If Access cannot accomplished that then I'll have to switch Oracle or go AI for answers, because I'm not getting any from Tech help.

This the answer AI gave me:
Private Sub FieldName_Exit(Cancel As Integer)
    Dim rs As Recordset
    Set rs = Me.RecordsetClone

    ' Search for the record you want to lock based on a unique identifier '
    rs.FindFirst "ID = " & Me.ID.Value
    
    If Not rs.EOF Then
        ' Lock the record to prevent other users from editing it '
        rs.Edit
        rs!Locked = True
        rs.Update
    End If

    rs.Close
    Set rs = Nothing
End Sub

The code is absolutely nonsensical.  It modifies a *field* named "Locked" instead of actually doing what you want.  ChatGPT is not yet reliable in code generation, as I've seen time and time again.  It doesn't seem to even understand what is actually requested of the code, let alone generating it reliably.  Give it another 5 years or less and maybe it will do better.

Other posters and I have already given you suggestions on how to do this in the other thread you started, so you should consider those instead.

- Access Split Database Seminar
- Access Security Seminar
- Access Data Encryption Seminar

Or move it to MS SQL Server
- Access SQL Server Online

Disallow Editing Data

NoLongerSet: Microsoft Access vs. SQLite: Security Comparison