Table in Subform is Open to Deletions

P

polisci grad

In my db, I open a table into a subform and turn off additions, deletions,
and edits. However, if the user right clicks on the field heading, they have
the option to delete the entire column. This is unacceptable.

How can I protect against this, without disabling and locking the subform
(since the scroll bar doesnt work when I do this)???

Any Suggestions?
 
O

Ofer Cohen

The properties you changed, is it in the main form or SubForm?
It should be in the SubForm.

Another way to do it, you can set the Lock property of the Sub form control
in the main form to Yes.
 
Top