473,888 Members | 1,551 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access 97 Multiple columns [comboboxes] on single subform

2 New Member
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.
Jan 3 '08 #1
3 2609
14,534 Recognized Expert Moderator MVP
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
Major Doug
2 New Member
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!
Jan 14 '08 #3
14,534 Recognized Expert Moderator MVP
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!
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

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 application is relatively big: around 200 tables, 200 forms and sub-forms, 150 queries and 150 repports, 5GB of data (SQL Server 2000), 40 users. I'm wondering what are the disadvantages of using Access as front-end? Other that it's not...
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 between the two subforms. But I put my mind to this again recently and came up with a solution (code below) that works well with multiple subforms to size both the heights and widths of the sunforms relative to each other, and it uses no additional...
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 database,just help in getting me pointed in the right direction. I have a database with 8 tables, which from what I have read, cannot be linked on a single form, and be updatable. I have created a query which includes all 8 tables, and then...
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 comboboxes in .NET. We are having success with the multiple columns similar to the combobox from Access 2002 (XP). Our biggest problem is speed. In a form in Access 2002, our combobox is able to load data in a table in separate Access database...
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 would you even continue to use Access as a backend when you have a much superior option in SQL express? What about as a future front-end development tool? Let's get serious. Microsoft continues to publish numerous articles and videos on how you...
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 has two subforms. One of the subform uses a physical test score which is basically four different fields while the other subform is one that has a written test score with three fields. Entry to both physical and written scores are done through this...
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 to look a and I am loosing tremendious amounts of time trying to organize it so that I could view it. Regards, Alexandre Brisebois
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, then import it into SQL Server. I've tried that, and the speed is acceptable. It is an ugly solution, however, and I expect to find a better one -- preferably a solution better integrated with the Access RDBMS. I've tried using an ODBC...
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. So i had a query for supervisors list where i put a condition under managers name: !! and also an after update requery Me.FA_supervisor.Requery. SO everything worked fine. Then i had to add more text boxes and combos to my form and it became
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.