Change which Subform AfterMain Form Open(?)

[tbl]

Is it reasonable to choose which subform is showing on a
form dynamically?

In other words, if a certain value in the current record on
the main form is selected, swap out the subform to a
different one. The subforms are continuous, if that makes a
difference. Access XP, if that makes a difference.

 

[John Vinson]

Is it reasonable to choose which subform is showing on a
form dynamically?

In other words, if a certain value in the current record on
the main form is selected, swap out the subform to a
different one. The subforms are continuous, if that makes a
difference. Access XP, if that makes a difference.

It's a specialized technique, and should only rarely be needed, but
yes you can do so; you'ld use the Form's Current event to determine
which Subform is appropriate, and change the SourceObject property of
the Subform control to the desired form.

This will very much slow navigation from record to record for the
user.

John W. Vinson[MVP]

 

[tbl]

It's a specialized technique, and should only rarely be needed, but
yes you can do so; you'ld use the Form's Current event to determine
which Subform is appropriate, and change the SourceObject property of
the Subform control to the desired form.

This will very much slow navigation from record to record for the
user.

Thanks, John. I'll continue to mull mull-over this one.
Maybe I'll come up with a differnt approach that doesn't
require this.