I'm trying to create cascading combo boxes but can't get it to work correctly.
I've followed the video by Richard Rost where the second combo box only lists the cities based on the state selected in the first combo box.
It fails to filter the second combo box list but works in his demo.
I have a main table & form called 'Finds' with controls called 'Cat' & 'Scat' to store the valves entered.
I have a 'Category' table with 'ID' (number) & a control 'Cat' (category name) also
I have a 'SubCategory' table with 'ID' (number) & a control 'SubCat' (category name) & control 'FindsCat'
Combo box 'Catcbo' for the category and 'SCatcbo' for the subcategory.
Both combo boxes display as they should as individuals but when I add the 'AfterUpdate' event for the 'Catcbo' combo as 'SCATcbo.Requery' the 'SCatcbo' box still lists all entries in the 'subcategory' table rather than only those that have the same data in 'FindsCat' ans selected with the 'Catcbo' combo.
I've created a 'SubCatSort' query based of Richard's query.
I suspect the problem it the query but several examples I've found use the same query structure. I even recreated Richard's example with the same names etc. and mine failed.
Where am I going wrong? Access 2007
I've followed the video by Richard Rost where the second combo box only lists the cities based on the state selected in the first combo box.
It fails to filter the second combo box list but works in his demo.
I have a main table & form called 'Finds' with controls called 'Cat' & 'Scat' to store the valves entered.
I have a 'Category' table with 'ID' (number) & a control 'Cat' (category name) also
I have a 'SubCategory' table with 'ID' (number) & a control 'SubCat' (category name) & control 'FindsCat'
Combo box 'Catcbo' for the category and 'SCatcbo' for the subcategory.
Both combo boxes display as they should as individuals but when I add the 'AfterUpdate' event for the 'Catcbo' combo as 'SCATcbo.Requery' the 'SCatcbo' box still lists all entries in the 'subcategory' table rather than only those that have the same data in 'FindsCat' ans selected with the 'Catcbo' combo.
I've created a 'SubCatSort' query based of Richard's query.
I suspect the problem it the query but several examples I've found use the same query structure. I even recreated Richard's example with the same names etc. and mine failed.
Where am I going wrong? Access 2007