By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,156 Members | 1,069 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,156 IT Pros & Developers. It's quick & easy.

Access 97 Multiple columns [comboboxes] on single subform

P: 2
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
Jan 3 '08 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi Doug

Have a look at this tutorial on Cascading combo boxes and let us know if you have any questions.
Jan 8 '08 #2

P: 2
Much appreciation and heartfelt thanks (saved me hours of pulling hair)!
Works like a champ and the tutorial showed me where I needed to go.
I luv this forum!
doug
Jan 14 '08 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Much appreciation and heartfelt thanks (saved me hours of pulling hair)!
Works like a champ and the tutorial showed me where I needed to go.
I luv this forum!
doug
You're welcome and I'm glad you like it :D
Jan 14 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.