Need help (big time) with setting properties on a subform.

[Guest]

I have a form with a subform and would like to set the "allow edits" property on the subform to True

I have no problem doing this on the main form with Me.AllowEdits = True

I have searched the help files and have checked my reference books but can not find out how I can set the Allow Edits property on my subform to true

Is there anyone out there than can help

Thanks
FatMan

 

[PC Datasheet]

From an event in the subform, Me.AllowEdits = True will work.
From an event in the mainform, use:
Me!NameOfSubformControl.Form.AllowEdits = True

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

I have a form with a subform and would like to set the "allow edits" property on the subform to True.

I have no problem doing this on the main form with Me.AllowEdits = True.

I have searched the help files and have checked my reference books but can not

find out how I can set the Allow Edits property on my subform to true.

 

[Allen Browne]

Try:
Me.[NameOfYourSubFormControlHere].Form.AllowEdits = True

Note that the name of the subform control can be different than the name of
the form its contains (its SourceObject).

For an explanation of the ".Form" bit, see:
http://allenbrowne.com/casu-04.html

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

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

I have a form with a subform and would like to set the "allow edits"

property on the subform to True.

I have no problem doing this on the main form with Me.AllowEdits = True.

I have searched the help files and have checked my reference books but can

not find out how I can set the Allow Edits property on my subform to true.