lock just one record

[Shawny]

Is it possible to not allow edits for just one particular record?

 

[Jack Cowley]

If your form displays single records you could put code in the On Current event to see which record is being display. When the one that can be edited is showing then change the Allow Edits from No to Yes.

 

[joeserrone]

Record Locking

Hi Jack,
Do you happen to have a working example of this?

 

[Gannet]

This might help

within the OnCurrent event you could look for specific data in one of your controls using:

If YourControl = SomeValue Then
        Me.AllowEdits = False
Else
        Me.AllowEdits = True
End If