View Full Version : lock just one record


Shawny
11-29-2001, 08:57 AM
Is it possible to not allow edits for just one particular record?

Jack Cowley
11-29-2001, 10:27 AM
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
01-30-2008, 05:47 AM
Hi Jack,
Do you happen to have a working example of this?

Gannet
01-30-2008, 02:10 PM
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