Lock a single record in a form

[Delano29]

Hi,

I am using Access 2000. I have this form that brings up selected records in a table to edit, delete, etc. I have this one particular record in the table that is linked to the form that I do not want deleted or modified by the user in any way (I am sort of using it as a place holder in certain other forms and reports). Is there a way to lock this single record in the table/form using code or any other method?

Thanks in advance.

 

[PHV]

In the Current event procedure of the form set the AllowDeletions and AllowEdits properties depending of your particular record.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886