Query on the basis of form & bound sub-form

[nndkol]

In ms access 2007, I have a form & a sub-form bound to the form. Also I have a query having fields from the form & the sub-form.One Text Box in the sub-form has primary key and Id to relate the entire record.
I need to show the filtered data in the Query only which in the form & the sub-form. I have a command button with onclick event to open the Query with filtered data as per the form & the sub-form.
I have tried to put the criteria in the Query as [Forms]![FormName].[TextBox] or [Forms]![Sub-FormName].[TextBox] or[Forms]![FormName]![Sub-formName].[TextBox]
But When I click the button, it pops up=> [Forms]![FormName].[TextBox] seeking the value of the Text Box...... When I put the value of the Text Box there, it opens the filtered data in the Query.
Kindly help me how to generate the Query as per the data in the form & sub-form.
(Lastly I like to humbly inform that I know nothing about access & vba. So far I have tried on the basis of knowledge shared by philanthropic people like you in the forum. Kindly forgive me If I don't use exact terms to describe.)
Thanking all in antecepation

[PhilOfWalton]

The way to refer to a Text Box on a subform is:-

Forms!FormName!SubFormName.FORM!TextBox

You were close, but missed out the .FORM (Capitals are not needed)

Phil

[nndkol]

Thanks Phil for your kind response.
Your suggestion solved the issue.
Also I tried [Forms]![FormName]![Sub-formName]![TextBox]- it works
Thanks again. Regards