Subform and Form and report

[rogerarce]

I have a form called myform, there is a subform in the same
form called mysubfom.

In my report I get information calling a query. Now, myform
has some information that I pass to the report using:

[Forms]![myform]![Product]

My problem is that I can not get information from the
subform mysubform. I need to get the info from the
filed [Price] what should I use? I hope you undestand
what I mean.
Thanks for your help in advanced


Roger

 

[Eupher]

I believe this should work...

[Forms]![myform]![mysubform].Form![Price]

HTH...

Ken S.

 

[Eupher]

p.s. Here's a good resource for referring to subforms:

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

Ken S.

 

[rogerarce]

Thanks for your response, both worked fine.

Roger