473,549 Members | 2,625 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 2175
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...
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)...
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...
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,...
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...
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...
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...
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 ...
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...
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...
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...
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...
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...
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...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
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...

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.