Graph

[Benj]

Good day! I've placed a Graph in the Main form, unfortunately, the criteria I've used [Forms]![Main]![ID], shows all the records. I want the graph to show only for the current record.
SELECT Collection.ID, Collection.Number_of_Tubes, Collection.Collection_Date FROM Collection WHERE (((Collection.ID)=[Forms]![Main]![ID])) ORDER BY Collection.Collection_Date;

Thanks in Advance!

[ranman256]

does the query work with the criteria?
make sure the query PARAMETERS have your path: [Forms]![Main]![ID], as long integer

if so, run the query,
copy a few records from the recordset,
open the chart,
select the chart object
does the ROW SOURCE have the correct query

dbl-click the chart object
the chart AND datasheet should show, if not, menu:view, datasheet
select the top left corner of the grid and delete all records,
paste your result data in the grid.
close the report and save.

see if that works.

[June7]

My graph RowSource references textbox with identifier. Example:

SELECT Size, Pass, Hi, Lo FROM GraphBMD WHERE LabNum=[tbxLabNum] ORDER BY Size;