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

S

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
 
B

Brendan Reynolds

Simon said:
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
Click to expand...


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.
 
Top