Cascade Combo Box Previous CD Group List Box

[mikevds]

I need directions on Cascade Combo Box
So when I select
CD Group
Displays only the CD's in that Group that are related to that Name
So what fields would I have to set up for CD Group and CD NAme with that Table.
Someone emailed me an article on Cascade combo boxes what fields so I need for the coding.


Just like Bakery Products

Nabisco
Chocolate Chip Cookies
Sugar Cookies
Quaker
Oat Meal Cookies

I want it to remember the value from the Bakery Products box so it only display those values or items in this case "Cookies" Related to Products Not all the Cookies in the Database

 

[Ukraine82]

Mike,

If you do a search on cascading combobox you will find a lot of sample databases.

hth,
Michael

 

[Ukraine82]

This is what cascading combo box looks like.

If you go to design view and look at the property for combo box you will notice event procedure for after update. Take a look at the code.

I'm also attaching you a sample database. You can try and play around with it.

hth,
Michael