auto populating list box based on two dependant combo boxes

[tommyried]

hello everyone,

can anyone tell me how to auto populate list box based on two dependent combo boxes ,any sample DB or material so that I can practice.


thanks

[pbaldy]

Likely an extension of one of these methods:

http://www.baldyweb.com/CascadingCombo.htm

[tommyried]

thanks paul for your quick reply but I know the concept of dependent combo boxes what iam looking for is to link second combo to a list box so that when I choose a field from second combo the list box should auto populate based on selections.

thanks

[pbaldy]

Perhaps I'm missing something, but I don't see how it would be any different. A listbox and a combo are basically the same from a row source perspective. Perhaps you can post a sample db?

[tommyried]

please find attached sample db.

[pbaldy]

Well, the listbox row source doesn't have a criteria, so I pointed it to the combo to use the same method you used with the combos. The combo's after update event was requerying the form rather than the listbox. With those 2 changes it appears to work.

[tommyried]

still I cant figure it out combo 1 or combo 2 ? can u please send me the sample db which u have modified.

[pbaldy]

I'm out and about right now, but the process is exactly the same as with the combos. Have the row source of the listbox use the combo for a criteria, and requery the listbox in the after update event of the combo. I'm pretty sure it was named combo1, but was the second combo on the form.

[tommyried]

thank you very much paul its working now.

[pbaldy]

Happy to help.