Combo box options controlled by textbox selection

[Suzanne Joy]

I need to create a combo box whose drop-down options are controlled by what is selected in a preceding textbox. How do I set this up?

Specifically, I need for state-specific county FIPS codes to appear in the drop-down list of the combo box when a specific state is selected in a state textbox. I have set up the combo box to use a table of fips codes, which also contains states, although I have only the fips codes column appearing in the drop down list.

Thanks in advance for helping!

 

[Rich]

Search here for cascading combo boxes