Cascading combos in a form

[jessaw]

Hi,


I am trying to create a form with cascading combo boxes. i.e. I want make a selection in the first combo box, which then narrows down the fields in the second combo box and the same for the third combo box. I have tried using a query for the second combo box based on my results from the first combo box but depending on which thread I read I end up with different result but none of them give me my desired outcome.Needless to say I have not even attempted the 3rd combo box.

In this scenario if have created a combo box with the information taken from the Site table.
I have created a query to give me the route using the selected site in the combo box on the form. [Forms]![Routes]![Combo16]
This is where it comes to an end because the query gives me no output.

Being a newbie to Access any help would be appreciated

[June7]

Does this help http://datapigtechnologies.com/flash...combobox2.html

Show the RowSource of comboboxes.

Is form in Single, Continuous, or Datasheet view?