Protecting records after entered on data entry form

J

Jen

I have a mutiuser database for Access 97 that I want to protect a record once
it has been entered on a data entry form so it cannot be deleted. Some of
the field are protected for no data to be entered, but I need other fields on
the form to allow entry but no changes. I have checked through the on-line
help and some books but apparently am not looking in the right areas.
Any help is appreciated.
 
R

Rick Brandt

Jen said:
I have a mutiuser database for Access 97 that I want to protect a record once
it has been entered on a data entry form so it cannot be deleted. Some of
the field are protected for no data to be entered, but I need other fields on
the form to allow entry but no changes. I have checked through the on-line
help and some books but apparently am not looking in the right areas.
Any help is appreciated.
Click to expand...

The form has a property named AllowDeletions. Set it to No.
 
S

Steve Huff

There is a propety of the form "Allow Deletions" - the easiest thing to do
is set this to false.

-Steve Huff
 
Top