473,287 Members | 1,865 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

Access 97 Multiple columns [comboboxes] on single subform

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
3 2587
MMcCarthy
14,534 Expert Mod 8TB
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
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
14,534 Expert Mod 8TB
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

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

Similar topics

49
by: Yannick Turgeon | last post by:
Hello, We are in the process of examining our current main application. We have to do some major changes and, in the process, are questionning/validating the use of MS Access as front-end. The...
7
by: lauren quantrell | last post by:
A while back I got a requirement for the client to be able to adjust the relative heights of two subforms by click-dragging the mouse and I came up with a kludge solution using a border control...
11
by: dskillingstad | last post by:
I've been struggling with this problem for some time and have tried multiple solutions with no luck. Let me start with, I'm a novice at Access and I'm not looking for someones help to design my...
2
by: SKarnis | last post by:
We are trying to rebuild a current Access 2002 (XP) mdb program to VB.NET with a SQL database - we are having problems with a suitable combobox. There are many threads discussing multiple column...
37
by: jasmith | last post by:
How will Access fair in a year? Two years? .... The new version of Access seems to service non programmers as a wizard interface to quickly create databases via a fancy wizard. Furthermore, why...
6
by: Jack | last post by:
Hi, I have an Access application which need to be converted to asp-sql server application. This Access application uses a single form. This form has got a SS number with names and age. The form...
4
by: alexandre.brisebois | last post by:
Hi, I am using access 2003, I would like to know if there is an option to reorganize the tables in a maner that is readable, as we can do in sql sever 2000 or 2005. I have been given a database...
20
by: TC | last post by:
I need an automated procedure to copy data from an Access table to a SQL Server table. Speed is important. What is the recommended technique? I can export the data from Access, copy it via FTP,...
2
by: Mike | last post by:
Hi guys, i have a form(myform) where i connected a pair of comboboxes for managers and supervisers, so when you choose a manager the second combo shows only those supervisors who report to him....
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.