Cascading boxes won't work when in subform within another subform???

[amyceres]

I have a problem with cascading combo box not working.



I have a one form and with two subforms

One form is "frmReviews" with a subform called "frmbyReviewer" Link Master Fields = Name and Link Child Fields = Reviewer_Name

Then we have the "frmbyReviewer" with a subform called "frmsubMain" where it's Source Object is another form called "frmMain" and linked by Loan_Number
Here's the Design View of it.

[June7]

Would have to see the combobox RowSource sql.

I expect it can be done but have to get the form referencing syntax correct.

The comboboxes of issue are on the third level form frmsubMain?

Going through multi-level forms is challenging.

Cascading comboboxes with lookup alias don't work nice on continuous or datasheet view form.

BTW, names make poor PK/FK links.

Name is a reserved word. Should avoid reserved words in naming convention.