Hello:
situation--I have a research database. Each record in the database consists of 10 fields. I used access97 to rack/stack my database; very easy in the beginning. I created a form with a combobox. Using some information I found through this forum, I created the comboxbox in the form's header linked to textboxes in the form's detail. I could click on the column and see the linked data populate the 10 textboxes. I could easily maneuver through the column to find the title that I needed and click on it to see the linked data in the text boxes. Then, my research changed and I needed to discriminate the records based on new variables. I have 9 variables. So, I built 9 forms; one for each variable. I used a tab control form with 9 tabs; again, one tab for each variable. Then I reproduced a subform on each tab with a combobox in the form's header linked to textboxes in the form's detail. To recap: I can click on a specific variable (tab) and using a combobox linked to textboxes pullup linked fields.
Now my research has changed again and requires a second level discriminator. I am using the variable of time--short, mid and long--to filter my data.
I initially attempted to place a tab control within a tab control, but have found out through this forum, that it is not quite that easy. Doing some homework I was able to overcome the tab within a tab challenge. However, I am not overly thrilled of the appearance of a tab within a tab to discriminate the 9 variables against time (I open form, select tab of specific variable and then select tab to choose time variable).
My questions for forum: is there a technique for placing 3 comboboxes in a forms header (each form represents one of the nine variables with each combobox representing a time variable) whereupon I could click on each combobox and have its associated data populate text boxes in the forms detail?
I would not need to see all the data from the 3 comboboxes to populate at the same time--just need each combobox to populate text boxes when I click on a title in a combobox. If 3 separate comboboxes can not populate the same text boxes in the same form, could I use a command button or toggle to switch between the comboxes?
Thanks in advance for any insights.
doug