Refer to sub-form from main form

[burrina]

I dont know why I have trouble with this but I always do. Main form is named Add Products and sub-form is named Add Products SubForm



I am trying to disable the control TaxStatus on the subform. I tried the below with no luck.


Forms![Add Products]![Add Products SubForm].Form![TaxStatus].Enabed = False


OK, I changed the form names so that NO spaces are there, i.e. AddProducts and AddProductsSubForm

[RuralGuy]

What is the name of your SubFormControl? That is the control on the [Add Products] for that displays the [Add Products SubForm] SubForm. Not a real good idea to have embedded spaces in an object name. Better to use CamelFontNames.

[burrina]

Yes, I know it has spaces, my bad. Anyway the name of the subform, see above; is Add Products SubForm and the control is named TaxStatus


I dont know what CamelFontNames are btw?

[RuralGuy]

Your MainForm has both a SubFormControl *and* a SubForm on it. The SubFormControl is used to display the SubForm on the MainForm and has the Link Child/Master Fields properties on the "Data" tab of the property sheet and the control name on the "Other" tab. I've been using CamelFont in this posting and as you can see it is very readable without spaces in the word.