Row Source URGENT

G

GR

Hi, I posted a message on Queries Newsgroup (jan 19
4:34am) unffortunately I didn't get an answer... maybe I
wasn't clear... pls if someone can refer to that post and
can help me I will appreciate it tons.

Now I'm trying to find other ways to accomplish the same
task. I have problems with a Chart object in a Report. The
chart is displaying the whole data and not the data for
the group I want.
I have two groups, Project group and Reading group. I want
a chart for each reading.

In what section event (I put the chart in the Reading
Header section) shall I code in order that I can change
the Row Source of the chart object every time a new
Reading is read?? Also, how can I send a variable (which
will contain the current reading) to the Query underlying
the chart??
E.g.
Now the Query looks like:
SELECT qryTrendVMS.SubProduct, qryTrendVMS.Readings,
qryTrendVMS.Value FROM qryTrendVMS;

And I want something like:
SELECT qryTrendVMS.SubProduct, qryTrendVMS.Readings,
qryTrendVMS.Value FROM qryTrendVMS WHERE [Readings] Like
CURRENT READING;

Where CURRENT READING I already tried to put it as an
unbound text box, a variable and not working. Also
WHERE [Readings] Like [Reports]![rptTrendVMS].[Report]!
[txtCurrentReading]
Doesn't work.

Any ideas??
 
Top