non deletions of records

  • Thread starter Thread starter JohnE
  • Start date Start date
J

JohnE

I have a form that the user should be able to enter and
edit a record but not delete. I did the AllowDeletions to
No and the DataMode off. But info was still able to be
deleted. Is there a way to better protect a form (other
the locking the fields) that prevents the the field(s)
from getting deleted?
*** John
 
Setting AllowDeletions to No will prevent records from being deleted but will
not prevent users from highlighting individual controls and deleting the data in
the control. You can open the table that the form is based on in design view and
set the Required property to Yes for those fields you do not want deleted in the
form. When you first create a record on the form you will then have to enter
something in the control and after that you will be prevented from deleting the
data in that control.
 
Back
Top