Design question

[Guest]

I am trying to develope a database that tracks scorecard used for Quality
Assurance purposes. I have no problems with the creation on a single
scorecard. My problem is that each scorecard contains a different number of
questions and I would like to have each of the scorecards to "pop up" if
selected in my textbook for that scorecard type. Can this be done? Thanks
Scott

 

[Guest]

Yes, it can be done. One way would be to create all the controls necessary
to complete the scorecard with the highest number of questions.
Make all the controls invisible.
Put a combo box on the form to allow you to select a type of scorecard.
Use the After Update event of the combo box to make visible the questions
for the type of scorecard selected. If the questions are different for
different scorecards, you can populate the caption property of a label before
you make it visible.