>Hi -
>
>I have stumbled upon a "search" form that I have a few questions:
>
>Scenario:
>
>I have a form called "Office Search Form". On this form are 4 combo boxes. They are the following:
>
>A. State:
>B. County:
>C. City:
>D. Office:
>
>When a user selects any one of these combo boxes, he/she currently is selecting the "default" view for that combo box. That is the way I have it set up now. For example, if you clicked on the "state" combo box, you would have a choice of Florida or Alabama. If you clicked on the "county" combo box, you would see all the "counties" for EACH state, etc.
>
>
>**** I would like to have the user select a specific state, be it Florida or Alabama, and have the following combo box [counties] reflect only the "counties" in the selected state......not both. Then, when the user selects the "county" he/she wants, the "cities" combo box only reflects the "cities" in the "county" that is chosen, not all cities that the VIEW is storing.
>
>
>I hope this is clear and those that are reading this understand what I am trying to accomplish.
>
>I would appreciate any feedback on how to develop/create my views or place code where I need to, in order to make this work.
>
>
>I just don't understand how to make this happen, when I already have a specific view tied to the combo box. There must be a way that as soon as "FL" is placed in the first box, an event is automatically fired that populates the view for the next combo box with correct information.
>
>TIA
>
>Jason

Jason,

What you are after would be better achieved with a treeview control. It might sound hard in the beginning, but it's really not that much.

José