Querys like [forms]![frmSearchProducts]![ProductSearch]

[Simon]

I am buiding a query that will query information based on some text
that is entereed with in a subform

I know the code is for using text on a form
[forms]![frmSearchProducts]![ProductSearch]

Buti can nor remeber the code for then the text is in a subform
(frmSearchProductsSubform)


Thanks

Simon

 

[Allen Browne]

Try:
[forms]![frmSearchProducts]![Sub1].[Form]![ProductSearch]

For an explanation of the .Form bit, see:
Referring to Controls on a Subform
at:
http://allenbrowne.com/casu-04.html

 

[Brendan Reynolds]

I am buiding a query that will query information based on some text
that is entereed with in a subform

I know the code is for using text on a form
[forms]![frmSearchProducts]![ProductSearch]

Buti can nor remeber the code for then the text is in a subform
(frmSearchProductsSubform)


Thanks

Simon

Forms!NameOfMainForm!NameOfSubformControl.Form!NameOfTextBox

The thing to remember here is to use the name of the subform *control* which
may not be the same as the name of the form that it contains. Look at the
properties of the subform control in design view to determine the name.