"Jim Allensworth" <ji****@datacentricsolutions.com> wrote in
news:40****************@news.west.earthlink.net:
On Thu, 22 Jul 2004 17:48:15 GMT, Blah <me@nowhere.com> wrote:
Hello,
I'm trying to use the where clause in OpenReport to limit the data
return on the subreport. Is there a way to do it using that method or
OpenReport only work with the report you're opening?
Thanks
How the subreport is linked should take care of that. The Where
condition will work on the main report and the subreport will be
constrained by the linked fields.
- Jim
Thanks for the quick reply but that's not what exactly I'm looking for.
I forgot to say that the records in the SubReport contain a date. I want
to limit the return by giving it a date range. So like this.
Main Report: all the contact info of a company
Sub Report: all the order they have in the month
I'm not using a form to pass in the parameters but VBA instead.
When I go open the report by double clicking on it, it return the correct
information in the report and all the order record in the sub report.
Thanks