Cascading Combo Boxes

[johnwayneoftheseas]

I know that answers about this are posted all over the internet, but for whatever reason, after hours and hours of fruitless attempts, I'm simply unable to apply what's on the internet to my specific case. I appreciate any help you can provide!

What I want is two cascading combo boxes that will, after the user's selections, display a final subform with the results. (I know, this ought to be cake, but I just can't seem to wrap my head around it.)

To make things simple, I put everything I would want displayed in the subform in one table, called tblAllUNITEVTC. This table contains the following field names:
- Name (The names of the teachers that will be displayed in the subform)
- Description (Whether the teachers are currently enrolled in the program or not - this is what I want to choose in the second combo box)
- ProgDescription (The name of the program the teacher is/was enrolled in - this is what I want to choose in the first combo box)
- Notes (Any notes about the teacher. I'd like this displayed in the subform.)

So. To summarize, I want to select one combo box to determine which program I'd like to look at. I want the second combo box to be dependent upon the first, and I'd like to choose those people currently enrolled in the program (for example). Once I've selected that, I would like to display a subform that shows the Name, Description and Notes.

I know that Combo Box 1 (called cboSelectPgm) needs to have a row source from tblAllUNITEVTC.ProgDescription and that I need to requery Combo Box 2 After Update. And I know that Combo Box 2 needs to have a row source from tblAllUNITEVTC.Description

I'm afraid after that I get lost. I don't know how to correctly code the requery, either. I've tried all the examples I've found around, but none of them to any avail.

Thank you so much for reading, and again. Any help would be appreciated.

 

[dkinley]

Okay ... gonna throw alot at you in one demo ... It was taken off this site and produced by Siacom Systems and one of the best examples.

This should sort you. The thing to pay attention to is the rowsource of the subsequent combo boxes and how they filter the data in the criteria by looking at the previous combo box data.

The third combo box actually fills in some data on the form so you should see how that works, too.

Hope that helps.

-dK