Unanswered: Want to disallow record deletion in subform
I have used a subform to display records in a datasheet view based on certain search criteria on the main form.
My problem is that I am able to delete a record / all records simply by using the right click menu in the sub form.
I dont want the users to have the ability to add/edit/delete records.
The only explanations for that are that code somewhere is turning it back on or you've set it for the wrong form. Do a search in your code for AllowDeletions and see if it's being set on again.
You can also confirm what the setting is by putting a MsgBox Me.AllowDeletions into the OnClick event of something easy, maybe the form's background. Then you can check the property at runtime to see if it's set correctly.
One more thing... the right click menu you are talking about... is it a standard shortcut menu or a custom one? If it's a custom one it might do the deleting via VBA and a refresh. AllowDeletions wont stop that.