Properties of sub forms

  • Thread starter Thread starter Rolf Rosenquist
  • Start date Start date
R

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
 
To refer to the form in the subform control, try this:

With Me.[NameOfYourSubformHere].Form
.AllowDeletions = False
.AllowEdits = False
End With
 
Just the right thing. Works great!
Many thanks for your help.

/ Rolf


Allen Browne said:
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.

Rolf Rosenquist said:
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.
Click to expand...
Click to expand...
 
Back
Top