Prevent row from being deleted

[Murray]

Hi all
I have a form with a subform on it. The subform is displayed in Datasheet
view. If a user right clicks on a row it allows for the user to insert a new
record or deleted the current record. Is there a way to prevent the user from
deleting the record?

Thanks

 

[gllincoln]

Hi Murray,

Sure - set the sub-form's property 'allow deletions' (in design mode, property sheet) to false.

Gordon

 

[John W. Vinson]

Hi all
I have a form with a subform on it. The subform is displayed in Datasheet
view. If a user right clicks on a row it allows for the user to insert a new
record or deleted the current record. Is there a way to prevent the user from
deleting the record?

Thanks

Are you talking about *deleting* the record from the table entirely, or
editing the content of the record so that it's effectively a replacement
record?