Problem with third cascading combo box - please help.

warren0127

New member
Local time
Today, 14:38
Joined
May 14, 2015
Messages
2
I have a requirement that will need three cascading combo boxes - the second box should only display the contents that match or are relevant to the first combo box, etc.

I followed a tutorial on YouTube - unfortunately I cant post the link since I have not had more than 10 posts :(

The title of the YouTube video is:

Microsoft Access pt 9 (Cascade Combo Box)


It seems the first and second combo boxes cascade and works fine. However, the third combo box remains blank after the second combobox selection has been made.

I have three tables: Customer, CustomerSubOrg, and PORs. I have setup lookup fields that are using Primary keys for two of the tables (CustomerSubOrg and PORs). However, I ensured that the primary key fields display as the "Names" of each instead of the numbers. I also ensured I went back and changed their data type to "Text" instead of "Number" so the text appears (which seems to have worked for box #2).

Does anyone know what I am missing, to get the third combobox to display its contents? I've attached some additional screen shots below. I know the problem is within the second combobox -- perhaps the query needs some adjustment?

Unfortunately I cannot attach images yet since I am now. But I basically created two queries and used them each for the second and third combobox.

The comboboxes on the form:

Customer
Sub Organization
POR


The Suborg query looks like this:

Table: CustomerSubOrg

First Column:
From field SubOrg
From table CustomerSubOrg

Second Column:
From field CustomerID
From table CustomerSubOrg
Criteria [Forms]![frmMain]![cboCustomer]


The POR query looks like this:

Table: PORs

First Column:
From field PORName
From table PORs

Second Column:
From field SubOrgID
From table PORs
Criteria: [Forms]![frmMain]![cboSubOrganization]


Why wont the contents from the third combobox appear?


Thank you much.
- Warren
 
Sorry for the duplication of this post. I was just looking to get as much help as possible. Appreciate the link I will certainly check it out!
 
Could you post your database with some sample data, zip it because of the 10 post.
 
in the second combo box
open property sheet
then in data tab
open the row source and add the first field and in ceretria put the first combo box

and open VBA for the first combo box
and @ after update event

type

Combobox2.requery
 

Users who are viewing this thread

Back
Top Bottom