Unanswered: Cascading Combo boxes based on school name
Hello I am trying to cascade 6 combo boxes. and its not working, there is someting I'm missing not sure what. What I am tryign to do is when the user pulls up a school from the drop down, all the information pertaining to that school is suppose to show up also. But that doesnt seem to be working. This is on an Access 2007 Database. the properties for the school combo box is . The Error message says "Method or Data Member not found" and its highlighting the "Private Sub School_Name_AfterUpdate()"
column width - 0";2";5.0299";0";0";0"
column count - 5
Record Source - SELECT DISTINCT SchoolInfID, school, str_addr, str_city, str_st, str_zip, cds_code FROM SchoolInfoSD_view WHERE (school IS NOT NULL) ORDER BY school.
thank you so much it works, the only problem is that when you look at the table all you see is the SchoolInfID you dont see the name of the school. Here is what I have in the combo properties. Everything is schronizing its just that the school name isnt showing in the table
Row Source - SELECT DISTINCT SchoolInfID, school, str_addr, str_city, str_st, str_zip, cds_code FROM SchoolInfoSD_view WHERE (school IS NOT NULL) ORDER BY school