sub form filter

[Gary Dolliver]

Hi all,
I have a form [MAIN], which has a subform [1] (child name is [1_sub]), which
then has 2 sub forms [a] (child is [a_sub]) and (child is [b_sub]). When
a record in subform [a] is selected, I am sending an email out, but notice
that I cannot set up WHERE criteria for a report attachment in the
DoCmd.SendObject line. So, I was working with the record source for the
report to see if I could filter from there, but how would I reference a field
in sub form [a]? Does it matter that it is 3 forms down? If I could be
shown some syntax, I would be very appreciative, thanks
-gary

 

[Klatuu]

From the main form:
Me!1_sub.Form!a_sub.Form!SomeControl or property

The logic behin this is 1_sub is a control on the main form. You reference
its SourceObject property with Form and then a reference to a_sub which is a
control on the form of 1_sub, then a control or property on the form object
of a_sub.

 

[Gary Dolliver]

Thank you so much, exactly what I needed!
-gary

From the main form:
Me!1_sub.Form!a_sub.Form!SomeControl or property

The logic behin this is 1_sub is a control on the main form. You reference
its SourceObject property with Form and then a reference to a_sub which is a
control on the form of 1_sub, then a control or property on the form object
of a_sub.
--
Dave Hargis, Microsoft Access MVP

Hi all,
I have a form [MAIN], which has a subform [1] (child name is [1_sub]), which
then has 2 sub forms [a] (child is [a_sub]) and (child is [b_sub]). When
a record in subform [a] is selected, I am sending an email out, but notice
that I cannot set up WHERE criteria for a report attachment in the
DoCmd.SendObject line. So, I was working with the record source for the
report to see if I could filter from there, but how would I reference a field
in sub form [a]? Does it matter that it is 3 forms down? If I could be
shown some syntax, I would be very appreciative, thanks
-gary