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