How can I make a Form that has future selections that will be refined based upon previous selections?

[kflau]

I want the Form to be able to refine the list of selections in one column based upon the selection made in the previous column. Suppose I have a Form with all NFL Teams. Behind the Form I have the data in these three corresponding tables, Conference -contains just NFC or AFC; Division - contains all 8 divisions; Teams - contains all 32 teams. In the first column, Conference, you have two choices NFC or AFC, I select NFC. In the second column, Divisions, now my selections will only be the 4 divisions of the NFC - NFC North, NFC South, NFC East and NFC West, I select NFC South. In the third column, Teams, now my selections will only be the 4 teams of the NFC South - Saints, Panthers, Bucs, Falcons, instead of all 32 teams.
Currently as I tab through the Form, when I get to the third column, Teams, I have to toggle through all 32 teams. Also, once I get to the final column, how can I enable the pick list so that someone could use the up or down arrow to move between choices? For instance, if both New York teams were in the same division, and as I get to the third column Teams, I type "Ne" both teams will appear in the pick list, but to get the team I want I would have to continue typing the entire city "New York" plus the first letter G for Giants or J for Jets to get to the team I want. How do I enable the arrows for selection? Thanks...and of course this is a hypothetical form, my data contains Areas, Districts and then Offices then Managers.

 

[jackd]

In general terms, I think you're looking at Cascading Combo boxes.
There is a free video tutorial here that deals with 2 combo boxes.
You might want to watch it and see if this is the sort of thing you're talking about.
http://www.datapigtechnologies.com/flashfiles/combobox2.html

 

[kflau]

Thanks a lot, that's what I'm looking for to make the form work.