Allow Deletions Isn't Working

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
 
L

Linq Adams via AccessMonster.com

The form isn't actually being used as a subform, is it? How the "Allow"
properties are set on a form is of no consequence if the form is being used
as the source for a subform. Since a subform is actually a control on the
main form, the "Allow" settings of the main form determine/override the
settings on the subform.
 
K

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
 
K

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
 
Top