473,721 Members | 4,008 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Dependent combo boxes and also unsure if need a sub-form???

21 New Member
First, I want to say thank you to Scott and the others who replied to my first post here. I had to put that database on hold for the moment when I was tasked with a new one.

I am building another database from scratch. This one is for job announcements. I've built only 2 tables (I know this is a no-no, but it was demanded by those wanting this database so I've complied). The field name properties and data types in both tables are virtually identical, so I'll just post one table. *and I apologize for the lenth of this post!!!*

  • JA_armyID Autonumber
  • Positions Number
  • Title Text
  • Para_Line Text
  • AreaConsiderati on Text
  • Location Text
  • Unit Text
  • DateRcvdJA Date/Time
  • OpenDate Date/Time
  • CloseDate Date/Time
  • NumberAppsSent Number
  • DateCertSent Date/Time
  • DateCertRcvd Date/Time
  • Selection Text
  • EOD Date/Time
  • Notes Memo

The other table name is t_Air with a different PK field name of JA_airID.

The reason the 2 are split up is because they do have different information that will later be added by the user in the form.

So, the first of 2 problems:
It is possible to have multi-positions come in for the same JA_ID (the PK). So if 5 positions come in, I need to be able to make 5 textboxes appear for the following fields:

After speaking to the computer guy here, he doesn't see how that's possible without a subform. It is desired for this to be a single-record form (and I believe that term to mean that one record displays at a time) but hopefully all that above information on the same record without having to click command buttons here, there and everywhere. And while it would be much easier to just create more field names in the event multiple positions are requested, that creates ALOT of used room for something not needed that often (5-10% of the time). Any suggestions on how to make that work?

Problem 2:
Dependent combo boxes. I have a good 150 pgs of research printed thus far and still can't find how. The desired scenario is as follows:

A combo box for data value "unit" in the form. This will bring up a drop-down list that states (for the ease of understanding) the following:

The problem is getting the dependent combo box control to work. For Units A-D, there are a variety of subunits. Subunits belonging to Unit A will not ever belong to another unit, same goes for ALL subunits. So again, for ease of understanding, Units and subunits together would look something like this:

So when the user goes into Unit and clicks "A" within that drop-box, another drop-box will appear with the options of "1", "11", "111" etc. But nothing other than the 1's.

I mean, there are about 50 million OTHER demands that these people want, but these are the 2 largest problems which myself and the computer guy absolutely don't believe we can work out.

ANY ideas are appreciated! Ideas, suggestions, whatever! Thank you so much if anyone replies!
Oct 4 '07 #1
4 2184
21 New Member
I just realized that maybe I should have also put that this is with Access 2003. Sorry about that.
Oct 5 '07 #2
23 New Member
I am also looking for a solution to problem #2. I found a useful link to another site which explained how do accomplish it, but it was written for Access 97 so either it doesn't work with Access 2003 or I'm doing something wrong when I attempt it. I'd certainly like to see a solution...
Oct 9 '07 #3
21 New Member
I did find this link on someone else's post [http://www.thescripts. com/forum/thread605958.ht ml]. I'm attempting it as we speak. I hope it works because I've certainly put alot of time and effort into it!
Oct 9 '07 #4
14,534 Recognized Expert Moderator MVP
I did find this link on someone else's post [http://www.thescripts. com/forum/thread605958.ht ml]. I'm attempting it as we speak. I hope it works because I've certainly put alot of time and effort into it!


You just can't create a database with the structure you have outlined. If some of the fields will have multiple values then they need to be in separate tables and you will need to use subforms to enter them.

Have a look at this tutorial on Database Normalisation and Table Structures. If you don't want to have a lot of problems entering and retrieving data you will need to look at the structure of your tables again.
Oct 11 '07 #5

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

Similar topics

by: TheThrill | last post by:
I'm trying to develop a few combo boxes. When a user selects a choice in Combo box "A" they have the choices "1, 2, 3, 4". Say they pick 3. They must then go to combo box "B" and when they pick 3 (from A) it only gives them the options "cat, dog, pig". However, if they were to pick 2 in combo box "A" it would give them the option of "donkey, horse, bear". I am guessing it is soem VB code to make this happen. anyone have any ideas?
by: Cillies | last post by:
Hi All, This message is a continuation of an earlier post, so please accept my apologies as I believe I would get a better response this way. Problem: I have 4 combo boxes which I want to able to enable/ disable depending on the selection made in the first combo.
by: Matt | last post by:
I am wanting to have the backcolor of some combo boxes change acording to what value is in the combo boxes in a report. The report can be one page to multiple pages with the same combo boxes on each page. The code I have tried is below. Sub Form_Current() Dim green As Long, yellow As Long, red As Long Dim x As Long green = RGB(0, 255, 0) yellow = RGB(255, 255, 0)
by: Tempy | last post by:
Good morning, I have 5 combo boxes that i need to hide when a text box has a certain name in it. I have tried the following, which works, but i have to select the box for it to work. I want the boxes to hide as soon as his last name is in the combo box "LastName". Private Sub LastName_GotFocus() If LastName = "Herbst" Then Supplier1.Visible = False
by: Brian Henry | last post by:
Here's an example of the code.. I have two combo boxes on screen that when one's selection is change the other's items will be updated to reflect the change (based on a relation) Private ds_formData As New DataSet ' ' Fill Line Of Business ' cmd_selectCommand.CommandText = "BENESP_GetLinesOfBusiness" da_formData.FillSchema(ds_formData, SchemaType.Source, "LinesOfBusiness")
by: Ron L | last post by:
I have a dataset whose source is a SQL 2k stored procedure that I am trying to display in a datagrid. This datasource has 4 columns that I am interested in here, a text column and 3 value columns corresponding to permissions to certain data classes. I want to put the permission values in combo boxes in the grid and instead of displaying the numeric values, have the combo box display a string that corresponds to the numeric value (i.e. No...
by: fieldja | last post by:
I have a form called OwnerForm. It contains a combo box called Owner. The combo box looks up names from a table called OwnerName. It contains fields called OwnerID and Owner. I also have a main form called ProjectsForm. This form has several fields to enter data. I have a query that is called Owner Query. This query contains the fields IDNumber.Projects2 Team.Projects2 and Owner.OwnerName getting information from tables. On the...
by: Dave | last post by:
I wasn't sure how to search for previous posts about this, it felt real specific. Ok so here's the database & problem: I have 4 combo boxes: cboServer, cboPolicy, cboDB, and cboApplication. The idea behind the database is for a user to search/ select desired information in any kind of combination between the 4 combo boxes. Then the user clicks a button (btnSearch) and subsequently a query ("Search Function") is run that shows all 4...
by: deanndra | last post by:
I thought I had it figured out yesterday. WRONG! I have 2 combo boxes, CBUnit and CBSub. When value is clicked within CBUnit, it should bring up corresponding sub-values in CBSub. These combo boxes are based on 2 tables; tbl_Unit and tbl_Sub. CBUnit has the following: RowSource: tbl_Unit ColumnCount: 2 ColumnWidth: 0";1.5" BoundColumn: 1 CBSub has the following: RowSource: SELECT tbl_Sub.AUTONUMBER, tbl_Sub.Sub FROM tbl_Sub ORDER BY ;
by: ARC | last post by:
I'm testing a user's db that contains a very large number of records. I have an invoice screen, with an invoice select dropdown box that shows all invoices, and the customer's name, etc. With 80,000+ invoices in this particular db, clicking the dropdown is painfully slow accross a network only (I'm testing on a wireless, so it's even slower still). All fields are properly indexed, such as the invoice number (sort descending), etc. I've...
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: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
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: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
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: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
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: 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.