Prevent row from being deleted

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Murray - 21 Feb 2008 22:00 GMT

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

Reply to this Message

gllincoln - 21 Feb 2008 22:53 GMT

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
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message

John W. Vinson - 22 Feb 2008 00:42 GMT

>Hi all
>I have a form with a subform on it. The subform is displayed in Datasheet
[quoted text clipped - 3 lines]
>
>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?

Signature

John W. Vinson [MVP]

Reply to this Message