Tab control

[snortby]

This may be a basic question, but this newsgroup has always provided me good
answers, so I am going to ask away! I want to show a tab control on my
subform, but base it on a recordset which changes with each record on the
main form.

In example:
Main form displays demographic data (one record only)
Subform displays children's data (if they have 4 children, 4 tabs would
appear when the subform opens). When you go to another record who has 3
children, 3 tabs would appear when the subform opens.

Is this doable? Any help is appreciated.

 

[Rick Brandt]

This may be a basic question, but this newsgroup has always provided me good
answers, so I am going to ask away! I want to show a tab control on my
subform, but base it on a recordset which changes with each record on the
main form.

In example:
Main form displays demographic data (one record only)
Subform displays children's data (if they have 4 children, 4 tabs would
appear when the subform opens). When you go to another record who has 3
children, 3 tabs would appear when the subform opens.

Is this doable? Any help is appreciated.

Likely possible, but not a great idea. Essentially the subform wouldn't
actually reside on the TabControl but rather in front of it and the
TabControl's change event would have to cause the subform to navigate to
the proper record. You would need to supply the TabControl with a "worst
case" number of pages and dynamically hide those you don't need.