Is there a way to lock records in o 1

[jommyjet]

Is there a way to lock records in one field so that they can never be changed?

 

[jrbarnett]

The easiest way is to make sure your data are accessible only via forms/reports, and that you can then set the form's locked property to true on the field even when editing records (ie only allow edits on new records).

John

 

[jommyjet]

how do you allow access to queries/forms only through reports? is it the isloaded property? thanks John

 

[jrbarnett]

First, have a proper user interface implemented with forms and commandbars, so you can then implement Access security to stop people accessing table/form/report design.

You can then have VBA code which conditionally unsets the locked property of the key textboxes if it is set to add a new record, or make it read only otherwise.

John