Exclude Specific Records From Editing?

[xweyer]

Is it possible to use code and a form to restrict editing to a specific range of records for a particular field?

I have a situation where I'd like to exlude a small range of records from being edited. I would want all records to be displayed and most available to be edited but a small number of records protected from editing when a particular condition were true (e.g. RecordID>3)

 

[RoyVidar]

This is perhaps more a forms question (forum702), but I think you could use the on current event of the form to toggle the .AllowEdits property of the form.

[tt]me.AllowEdits = (me!RecordID <> 3)[/tt]

Roy-Vidar