Subform Subform

[Dorian C. Chalom]

I need to do a Subform based off the Form
and a second SubForm based off the Subform...how do I do that?

 

[Damon Heron]

Design them separately then drag them onto their parent form. You are
familiar with the Master/Child linking process on subforms, correct?

Damon

 

[John W. Vinson]

I need to do a Subform based off the Form
and a second SubForm based off the Subform...how do I do that?

Just be sure that the first subform is in Single Form view - you can't put a
subform on a continuous subform or a datasheet.

 

[Dorian C. Chalom]

But I cannot select a field on the first Subform to filter the second
subform on...

 

[Damon Heron]

Maybe if you explain what you are trying to accomplish, someone may be able
to
help you with alternative methods to present your data.

Damon

But I cannot select a field on the first Subform to filter the second
subform on...

 

[John W. Vinson]

But I cannot select a field on the first Subform to filter the second
subform on...

Typically you would not do this with a Filter; if you set the Master Link
Field and Child Link Field properties of the sub-subform correctly (the Master
being the name of a field on the subform) you should get the same effect.

However you CAN indeed refer to a field on the first subform to filter the
second, if you wish to do so. What specific problem are you having? Are you
putting the second subform *onto the first subform* as a sub-subform, or
trying to put it beside the first subform (on the main form)? Even that can be
done if you wish...