Allow Deletions Isn't Working

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

I have a form (Access 2007) on which I've set the Allow Deletions Property to
No. For some reason though, my users are still able to go to Edit-Delete
Record and are able to delete the record. Is there some other setting that
needs to be in place in order to prevent deletions?

Thanks,

Keith
 
The form I am describing is not a subform...it is the main form.

Although I am designing in Access 2007, I am still saving as an Access 2000
mdb in order to accommodate users running older versions of Office. Could
this have something to do with it?

Thanks,

Keith
 
I'm replying to my own post (talking to myself?) because I figured out what
was wrong. The macro opening the form was overriding the Allow Deletions
setting. I created a new button opening the form using the wizard and
modified the code to do what I wanted, and the Allow Deletions:No stuck. I
hope this is helpful to someone in the future.

Thanks,

Keith
 
Back
Top