Properties of sub forms

[Rolf Rosenquist]

Did an attempt to set the property AllowDeletions for a sub form showed as a
data sheet. Did not work. But for the main form it works great. How can it
be done for the sub form? I really need it so the user don't do it by
accident, only the supervisor should be able to.

/ Rolf

 

[Allen Browne]

To refer to the form in the subform control, try this:

With Me.[NameOfYourSubformHere].Form
.AllowDeletions = False
.AllowEdits = False
End With

 

[Rolf Rosenquist]

Just the right thing. Works great!
Many thanks for your help.

/ Rolf

To refer to the form in the subform control, try this:

With Me.[NameOfYourSubformHere].Form
.AllowDeletions = False
.AllowEdits = False
End With

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Did an attempt to set the property AllowDeletions for a sub form showed as
a
data sheet. Did not work. But for the main form it works great. How can it
be done for the sub form? I really need it so the user don't do it by
accident, only the supervisor should be able to.