Question Cascading Comboboxes

[Gabi]

Hi,

As advised on my previous post, I have managed to fix the query issue "(Invalid parameter value)", working fine now.Thanks.

The issue, after setting up my 3 comboboxes to cascade, 2 problems occur:

1. Creates duplicates of entries when I click on the drop down arrow of the first combobox.
2. All these 3 comboboxes are just not cascading, just brings up a mixed sort of results.

This is how I have setup the cascading on the 3 comboboxes respectively.

Combobox 1 : SELECT tblClauses.ChapterTitle, tblClauses.SectionTitle
FROM tblClauses
WHERE (((tblClauses.SectionTitle)=[forms]![Clauses]![SectionTitle]));


Combobox 2: SELECT tblClauses.SectionTitle, tblClauses.ClauseNumber
FROM tblClauses
WHERE (((tblClauses.ClauseNumber)=[Forms]![Clauses]![ClauseNumber]));

Combobox 3: SELECT tblClauses.ClauseNumber, tblClauses.SectionTitle
FROM tblClauses
WHERE (((tblClauses.SectionTitle)=[Forms]![Clauses]![SectionTitle]));


I have set the event procedure to "Requery" on "Afterupdate"

Hope this is clear. Thanks

 

[isladogs]

Hi,

As advised on my previous post, I have managed to fix the query issue "(Invalid parameter value)", working fine now.Thanks.

The issue, after setting up my 3 comboboxes to cascade, 2 problems occur:

1. Creates duplicates of entries when I click on the drop down arrow of the first combobox.
2. All these 3 comboboxes are just not cascading, just brings up a mixed sort of results.

This is how I have setup the cascading on the 3 comboboxes respectively.

Combobox 1 : SELECT tblClauses.ChapterTitle, tblClauses.SectionTitle
FROM tblClauses
WHERE (((tblClauses.SectionTitle)=[forms]![Clauses]![SectionTitle]));


Combobox 2: SELECT tblClauses.SectionTitle, tblClauses.ClauseNumber
FROM tblClauses
WHERE (((tblClauses.ClauseNumber)=[Forms]![Clauses]![ClauseNumber]));

Combobox 3: SELECT tblClauses.ClauseNumber, tblClauses.SectionTitle
FROM tblClauses
WHERE (((tblClauses.SectionTitle)=[Forms]![Clauses]![SectionTitle]));


I have set the event procedure to "Requery" on "Afterupdate"

Hope this is clear. Thanks

OK a few things here Gabi

1. It would be helpful to provide a link to your previous thread so we can put your comments in context

2. Use SELECT DISTINCT to get unique records in your combobox

3. What exactly does this mean?

just brings up a mixed sort of results.

4. I can't see how you are using the output of combobox 1 to filter combobox 2 and similarly for box 3. Please clarify

 

[Minty]

The linking of your boxes looks like it cause an infinite (unresolvable) loop....

Box 1 is dependent on Box 2
Box 2 is dependent on Box 1
Box 3 is dependent on Box 2

By design the first two can't work independently. Box 1 shouldn't be dependent on Box 2, it should be the top level filter, and just an unfiltered selection.

 

[Gabi]

Thanks for both responses, I have managed to fix the combo boxes using your solutions/ suggestions.

Using Distinct to remove duplicates of entries in the top level box and resolving the loop as per Minty's advise.

 

[irsmalik]

Hi friends….. I am making a DB and I want to select Territory from Region Table + Company Table. now I am making Mistake at some point and I need your help. Here is the structure.

Table Company
CompanyID Number
CompanyName Text

Table Region
RegionID Number
RegonName Text
CompID Number
CompName Text

Table Territory
TerritoryID Number
TerritoryName Text
CompID Number
RegID Number

Form Name: Form1 with 2 Combo Box and one List Box

I want to select Company (from 2 Companies)
I want to select Region Associated with Company (from 29 Regions)
I want to select Territory Associated with Region (from 180 Territorities)

Kindly guide me how to do it.

Thanks
Irsmalik