Subforms showing continuous forms

[Timtropolis]

Greetings all,

I have a question regarding subforms that are set to show continuous forms and how they can relate to each other. I have attached a jpg of what i'm trying to do, you may want to open it so you can follow along with what I will now explain.

I have 3 subforms on a main form. The subform on the left shows high level info. A user would find the record they want in the subform on the left, double click, and that would in turn populate the two subforms to the right.

My question is how do I reference the name field in the record selected in the left subform , for criteria purposes in the queries for the right hand subforms? I thought maybe using the bookmark property but that hasn't worked.

Any help would be greatly appreciated.
TIA,
Tim

 

[MStef]

Hello Tim!

Try this:
[Forms]![MainFormName]![SubFormName]![FieldName]

 

[Timtropolis]

Hi MStef

First off, ty for responding!

Yes, what you suggested is already part of my code, however, what I am asking is how I can refer to a specific record on subform that is using continuous forms.

 

[MStef]

It's valid for current record in your subform, (which has the focus).