passing a value from a subform field to a query

[Guest]

I am trying to get a value from a subform to my query criteria. I have no
problem when referencing the main form - only subform. I think I have a
syntax problem.
I am using:
[forms].[formname].[form].[subformname].[fieldname]

 

[Richard]

Hi David

Try this link, it shows how to reference subforms

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

Richard

 

[Guest]

Thanks Richard,
this reference is helpful - but it doesn't seem to address what i am trying
to do - or i don't know how to read it.

Hi David

Try this link, it shows how to reference subforms

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

Richard

I am trying to get a value from a subform to my query criteria. I have no
problem when referencing the main form - only subform. I think I have a
syntax problem.
I am using:
[forms].[formname].[form].[subformname].[fieldname]

 

[Guest]

You mixed the order

Yours
[forms].[formname].[form].[subformname].[fieldname]

Should be
[forms]![formname]![subformname].Form![fieldname]

 

[Guest]

Thanks!

You mixed the order

Yours
[forms].[formname].[form].[subformname].[fieldname]

Should be
[forms]![formname]![subformname].Form![fieldname]
--
\\// Live Long and Prosper \\//
BS"D

I am trying to get a value from a subform to my query criteria. I have no
problem when referencing the main form - only subform. I think I have a
syntax problem.
I am using:
[forms].[formname].[form].[subformname].[fieldname]