Combo box & Subform

[Kill_Switch]

Hi all. I have been tinkering with a Combo box on the main form, and it's selection will dictate what is displayed on the subform. I'm sure you are all aware of what I'm trying to achieve. I have googled for some tutorials, found some examples but didn't work.

Anyone have a good example or tutorial so I can try myself tomorrow AM. Before posting my DB/full our specs here.


Thanks.

 

[Mr. B]

Here is the sample you wanted:

 

[Kill_Switch]

Thanks Mr B. I like that approach aswell, never thought of using an after update.

I looked at yours and while do so a light bulb clicked my head and I forgot to name the cbo correctly (can't spell ProcedureID), I had PrcedureID. Doh!

Just so other can learn as well, here is what I done.