dynamic tab control

[lparker]

I have three related tables... Groups, one to many with
PerformanceIndicators, one to many with Observations. How can I have the
number of tabs on a form change dynamically to reflect the contents of the
Groups table and be labeled as such. The tab would then display the
Performance Indicator records and subform for Observations records.

Thanks in advance for any assistance or pointer to additional reference
material. Access 2003

 

[Rob Oldfield]

You could....

a) Open the form in design view, add the relevant number of tabs, and then
switch to form view... or ....
b) Add 'more than enough' tabs to the design, and then set the ones that
you don't need to be invisible.

a) is going to be more reliable if you can't guarantee the maximum number
you're going to need, but is messy.
b) would be my choice if you can guarantee it

(There's also a c) of course.... use b but switch to a) on the odd occasion
you need more tabs.)