Populate on combo box based on another

[cluless]

Hey everyone,

I have two combo boxes in a form, and I'm trying to populate one based on the selection of another. I tried using someting like [Forms]![Form name]![Combo Box name] in the criteria of the query for the row source of the secondary combo box, but it doesn't seem to be working. What do I do? Thanks!

[RuralGuy]

It is called Cascading ComboBoxes or Lists and maybe this link will help.