vmccune
asked on
refer to control on subform of main form from a different subform
Hello,
I need to refer to a control on a subform from a different subform on the same main form. The two subforms are not nested but each is just a subform on the main form.
I need to refer to a control on a subform from a different subform on the same main form. The two subforms are not nested but each is just a subform on the main form.
If I've understood your names correctly then...
me.parent.CatAPSColorSize. Form!SumGD
The subform name is not part of the reference.
me.parent.CatAPSColorSize.
The subform name is not part of the reference.
ASKER
That gets #ERROR.
From the main form, I made a reference into the subform as below at it works fine.
=[CatAPSColorSize].[Form]!
ASKER
yours is working now as you gave it to me. I have noticed this before in 2007 that something seem to fail and then 5 minutes later start working. Thanks.
I think this:
me.parent.CatAPSColorSize. Form!SumGD
should be:
me.parent!CatAPSColorSize. Form!SumGD
me.parent.CatAPSColorSize.
should be:
me.parent!CatAPSColorSize.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks, glad to help.
ASKER
Subform to get the control reference from is CatAPSColorSize, field I want is SumGD
subform that will refernce the field is Summary