changing the 'AllowEdits' property on a subform

[Gerry Abbott]

Hi all,

Im wondering why the following will work
Me.Controls("subnonstorePos").visible = False

while
Me.Controls("subnonstorePos").AllowEdits = False
give me an
'property not support by this object error'
Any advice, alternatives, suggestions welcome.
Gerry Abbott

[Arno R]

"Gerry Abbott" <pl****@ask.ie> schreef in bericht news:6I*******************@news.indigo.ie...

Hi all,

Im wondering why the following will work
Me.Controls("subnonstorePos").visible = False

while
Me.Controls("subnonstorePos").AllowEdits = False
give me an
'property not support by this object error'

It is because ... 'the property is not supported by this object' ..
AllowEdits is a form-property, not a control-property.
You need the property 'Locked' I guess

--
Hope this helps
Arno R

[Allen Browne]

To explain Arno's answer further, you can refer to the form in the subform
control with the .Form property.

Try:
Me.Controls("subnonstorePos").Form.AllowEdits = False
or just:
Me.subnonstorePos.Form.AllowEdits = False

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Arno R" <ar***********@tiscali.nl> wrote in message
news:42*********************@dreader2.news.tiscali .nl...

"Gerry Abbott" <pl****@ask.ie> schreef in bericht
news:6I*******************@news.indigo.ie...

Im wondering why the following will work
Me.Controls("subnonstorePos").visible = False

while
Me.Controls("subnonstorePos").AllowEdits = False
give me an
'property not support by this object error'

It is because ... 'the property is not supported by this object' ..
AllowEdits is a form-property, not a control-property.
You need the property 'Locked' I guess

--
Hope this helps
Arno R

[Gerry Abbott]

Thanks guys.
Changed from the control to the form property and it works fine.

So some properties are controls properties, eg visible/locked etc,,
me.controls("mysubform").visible=true

while others are form properties, eg AllowAdditions, AllowDeletions, etc.
me.form("mySubform").AllowDeletions=true

"Gerry Abbott" <pl****@ask.ie> wrote in message
news:6I*******************@news.indigo.ie...

Hi all,

Im wondering why the following will work
Me.Controls("subnonstorePos").visible = False

while
Me.Controls("subnonstorePos").AllowEdits = False
give me an
'property not support by this object error'
Any advice, alternatives, suggestions welcome.
Gerry Abbott