Go to a record on one subform by clicking on another subform within a subform

[albouw]

I have read:

"Go to a record on one subform clicking on another subform."


My problem is how to go to a record in one subform by clicking on another subform within a subform.

I get an "expression not correct or too complex" error (translated, so not exact)

 

[Micron]

you should post the expression you tried along with the main form, subform and sub-subform names AND the subform control names for the subform and sub-subform.

 

[Micron]

Update: after reading the other post, and assuming you've set up the relationships as required, you need to get at the value of the nested control in order to navigate to the record. Sytnax for referencing control on a subform is
[Forms]![Main form name]![subform control name].[Form]![control name on subform]

To get at a second level (nested) subform, try this syntax
[Forms]![Main form name]![subform control name].[Form]![subform control name].[Form]![control name on subform]
[Forms]![frmScrollbar]![Child4].[Form]![Child6].[Form]![Text0] = "Test"
Worked for me on a mainform button click where the main had a sub with a sub.