Cascading Multiple Selections in a combo or list box

[abrown]

I have a form named "Classes" that gives all of the information about a class that is taught.

This form has the following fields:
Date


Class Name
Level (Multiselect Simple List box)
Category (Multiselect Simple List Box)
Objectives (Multiselect Simple List Box)
Instructor
etc.......

I can get the Level, Category, and Objectives to cascade and work fine when I have them setup for a single choice, but I need them to be setup to multiselect from all 3 and cascade (update) the choices as they are selected. Currently, with them being setup as multiselect I get the Level to appear but the Category and Objectives are showing up blank.

In the form I have the Level (Named ListLevel), Category (Named ListCategory), and Objectives (Named ListObjectives) being looked up to a Table called "Main Class Info" that has the fields as Text named Level, Category, and Objectives.

The Level Row Source Query Builder shows the following:
Field: Level
Table: Main Class Info
Totals: Grouped by
Ascending

The Category Row Source Query Builder shows the following:
Field: Category
Table: Main Class Info
Totals: Grouped By
Ascending

Field: Level
Table: Main Class Info
Totals: Where
[forms]![Class].[ListLevel]


The Objectives Row Source Query Builder shows the following:
Field: Objectives
Table: Main Class Info
Totals: Grouped by
Ascending

Field: Category
Table: Main Class Info
Totals: Where
[forms]![Class].[ListCategory]

Field: Level
Table: Main Class Info
Totals: Where
[forms]![Class].[ListLevel]

I have an after update event procedure for level and category shown below:
Private Sub ListLevel_AfterUpdate ()
Me.ListCategory.Requery
End Sub

Private Sub ListCategory_AfterUpdate ()
Me.ListObjectives.Requery
End Sub

I'm sure that I am missing something small in the code to allow for multiple selections but I don't know.

I need to be able to select level(s) (Basic, Intermediate, Advanced) and it give me the corresponding category list for the selections above. Then select Category(ies) from that list and it provide the corresponding Objectives list for the selections above.

For example:
I may have a class with the following criteria:

Basic, Advanced (I need this selection to only give me the Categories that correspond to Basic and Advanced)
Categories 1 and 25 (I need this selection to only give me the Objectives that correspond to Category 1 and 25)
Objectives 1.1, 1.2, 1.3, 1.4 and 25.1, 25.2, and 25.5

Please let me know what I am missing. I have researched and researched and can't come up with anything. I can provide a zip file if you can tell me how to zip a file and get it attached to this forum.

Thanks,
abrown

[huongdl1987]

To zip a file, you right-click the mouse, choose SEND TO and then COMPRESSED FOLDER. You need to make sure that the zip file is =<500GB, because any larger file won't attach to this forum.

To attach, click the attach button on top of the box where you leave your post (next to the smiling face). And then select Browse to choose file from your computer.

Good luck!

[abrown]

I can get the Level, Category, and Objectives to cascade (update) and work fine when I have them setup for a single choice, but I need them to be setup to multiselect from all 3 and cascade (update) the choices as they are selected. Currently, with them being setup as multiselect I get the Level to appear but the Category and Objectives are showing up blank.

If I could have them setup as combo boxes it would be better, but I think the A2007 version does not have that capability for combos, just list boxes.