Prevent row from being deleted

  • Thread starter Thread starter Murray
  • Start date Start date
M

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
 
Hi Murray,

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

Gordon
 
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
Click to expand...

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?
 
Back
Top