Combobox On SubSubForm Should Show Values based on Data from SubForm

[andrebmsilva]

Hello,

I have a PopUp showing the Product.
Then I have subForm showing the yarns.
Then I have a subsubForm where i need to select dying lots with a combobox.
I want to restrict the dying lots that show up in the combobox based on IDProductYarn present on subFormYarns.
How should I make a reference in the query of the combobox (in the subsubform) based on IDProductYarn placed on subFomYarns?
I've tried this, but didnt work:
Forms![subFormYarns]![IDProductYarn]
When i click on the combobox tells me to insert IDProductYarn.

Thank you

[pbaldy]

Wrong syntax:

http://access.mvps.org/access/forms/frm0031.htm

[andrebmsilva]

Hello,

Thank you for answering me.
I have tried a lot of different syntax and still wasn't able to get it working...
In the combobox i define the row source as a query and then in Criteria I've tried differente syntaxes but still nothing...

Am i doing it right?

[andrebmsilva]

This is the problem... the subform can't get the parent IDcorFio

[amrut]

Try using the expression builder to get the correct syntax.Select the main form first and then the nested subforms.

[pbaldy]

It still doesn't look like you've used the link to find the correct syntax. It would include the main form's name too.