Change which Subform AfterMain Form Open(?)

T

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.
 
J

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.
Click to expand...

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]
 
T

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.
Click to expand...


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.
 
Top