Discussions Search    Reviews    Search Aid    Buzzzz    Google@Omgili Add to iGoogle   Bookmark and Share

  Advanced Search



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

On Thu, 3 Jul 2008 01:15:49 -0700 (PDT), Simon <...@shos.co.uk

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

 Latest discussions from this group  (microsoft.public.access)

Converting list box column value to time  
[04 Sep 2008]
On Thu, 4 Sep 2008 01:22:27 +0100, "John" <info@nospam.info vis.co.uk Hi I have a list...
box on a form whose fifth column has values coming from a datetime table field formatted...
VBA if textbox is null  
[03 Sep 2008]
On Wed, 3 Sep 2008 07:35:45 -0700 (PDT), ghetto_banjo <adam.vogg@gmail. com in VBA, i ...
have an if statement checking to see if a text box is empty, if it is i want to display a ...
Changing  
[03 Sep 2008]
On Wed, 3 Sep 2008 11:26:02 -0700, Brenna <Brenna@discussio ns.microsoft.com Hi, I would...
like to know how to work with MS Access. First, my database is for a reservation system...
More...


On Thu, 3 Jul 2008 16:30:17 +0800, "Allen Browne" <...@SeeSig.Invalid

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Simon" <...@m3g2000hsc.googlegroups.com...
> (frmSearchProductsSubform)

On Thu, 3 Jul 2008 09:30:50 +0100, "Brendan Reynolds" <...@discussions.microsoft.com

"Simon" <...@m3g2000hsc.googlegroups.com...


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.

--
Brendan Reynolds