Trouble with vba code for cascading combo boxes

[msmithtlh]

I can't seem to get the syntax right for these cascading combo boxes.



I'm using these 2 tables

congregations - fields are Congregation_ID_PK, CongregationName, CongregationAddressID
individuals - fields are Individual_ID_PK, firstname, lastname, email, Congregation_ID_FK, teams_ID_FK

I need a combo box on congregations, then a second combo box on individuals in that congregation.

I got help with a similar situation, but am still struggling with the syntax.

Your help will be greatly appreciated!!!

[CJ_London]

rowsource for congregation combo - called cboCongregation

SELECT Congregation_ID_PK, CongregationName FROM Congregations ORDER BY CongregationName

rowsource for individuals combo - called cboIndividual

SELECT

Individual_ID_PK, firstname & " " & lastname as iName FROM individuals WHERE Congregation_ID_FK=[cboCongregation]

in the cboCongregation combo after update event put

cboIndividual.requery

Note the above is for 2 combos on the same single form

If you need more help, provide more information such as what you are actually using, a full description of your form and any subforms and where those combo's are located