Just added a new combo box to my select form.
Expand|Select|Wrap|Line Numbers
- Case "HouseEditDouble", "ParentsEditDouble", "ChildEditDouble"
- cboSelectHouse.RowSource = "SELECT HouseID FROM tblHouseDoubleEntry WHERE VillageID = '" & cboSelectVillage & "' ORDER BY HouseID;"
- Case "SchoolEdit"
- cboSchool.RowSource "SELECT SchoolID FROM tblSchoolSurvey WHERE VillageID = '" & cboSelectVillage & "' ORDER BY SchoolID;"
"Invalid use of Property" of cboSelectVillage
It is the same code as everywhere else, or have I missed something obvious, like a full stop or something?