Invalid use of Property

[Lysander]

Me again.

Just added a new combo box to my select form.

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;"

The line for cboSelecthouse, along with a dozen others, work. The new line, cboSchool, gives a compile error.

"Invalid use of Property" of cboSelectVillag e

It is the same code as everywhere else, or have I missed something obvious, like a full stop or something?

[twinnyfo]

Have you tried using the value your SELECT statement returns and run it in the SQL window? Everything "looks" OK, but I'd like to see the string generated in line 4.

[Lysander]

Sadly, this is a compile error, not a run-time error, so I can't even open the form to run it.

[Lysander]

If you are totally stuffed by a stupid error, give it to a non-programmer.
"Dear wife, look at these two lines of code, what am I missing"
"They are both the same Husband dear, except, one has a '=' sign, the other does not"

Four sodding hours of looking at this, and always looking at the SQL statement, never noticed the missing '='

Thank you darling wifey.

[twinnyfo]

Your wife is BRILLIANT!! Be sure to tell her!

[zmbd]

might I also suggest: a hug, a kiss, and take her out for a nice dinner!