This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a main form (fmMember) and 3 subforms nested within another. (Screenshot1)
Depending on what is selected from the combo box in subform1 determines what is available in the combo box drop-down in subform2. I have successfully referenced this in the Table/Query rowsource in subform2 as per 2nd screenshot. eg [Forms]!fmMember![subform1].Form![FoPPrimaryOption]
The problems is referencing correctly the Table/Query Rowsource for the combo box in subform3. Currently I have (http://access.mvps.org/access/forms/frm0031.htm) : eg [Forms]![fmMember]![subform1].[Form]![subform2].[Form]![FoPSecondaryOption] but it is not working and am wondering if someone can help me with the syntax please?
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Solution Solved: Forms![FormName]![SubformName].Form![SubSubformName].Form.[ControlName]
For future reference you may find the following link helpful for this type of question.