I have been developing a database containing power plant information and I want to be able to retrieve information in two ways. The first is by information category such as plant administration, plant description, plant fuel inventory, and so on. This information is presented in several forms and each form is a different information category. The user views information for different plants by using the next record button at the bottom of the form (ugh). I would like the second means to be selecting a specific plant by clicking on a list, and branching to a form containing the plant name and maybe a tab control for the five different information categories.
My original thought was to use a combo box to effect the branch but, after running a search here and reading the results, now I am not so sure that a combo box is the way to go. They seem to be more suited to data entry and not execution control. I have some event procedures for moving from one form to another as the user drills down into the database but the approach would require a form with 127 controls. The resulting form would be too crowded, too hard to read, and too complex. There almost has to be an easier way. Any suggestions?
Steven L. Ross
My original thought was to use a combo box to effect the branch but, after running a search here and reading the results, now I am not so sure that a combo box is the way to go. They seem to be more suited to data entry and not execution control. I have some event procedures for moving from one form to another as the user drills down into the database but the approach would require a form with 127 controls. The resulting form would be too crowded, too hard to read, and too complex. There almost has to be an easier way. Any suggestions?
Steven L. Ross
