Graph

[AlexBen]

Good day! I have a graph that should show only the current record. I used [Forms]![FormName]![FieldName] for the criteria. Every time I would open the form, it would ask me that. The SQL in the ROW SOURCE for the graph is SELECT GraphRaw.BoarID, GraphRaw.CountOfCollection_Date, GraphRaw.SumOfTubes, GraphRaw.BiWeekly, GraphRaw.Year, Round([SumOfTubes]/[CountOfCollection_Date],2) AS Ave FROM GraphRaw WHERE (((GraphRaw.BoarID)=[Forms]![Main]![Boar_ID]));

Thanks in advance!

[CJ_London]

Is the sql actually in the rowsource or in a query and the rowsource is the query name?

and what is the form you are referring to? Main?

[June7]

Is Main form already open when form with graph opens?

Is this graph located in a form used as subform on Main?

I presume BoarID is in the graph form's RecordSource so I would name a textbox holding that value to tbxBID then change WHERE clause to: BoarID=tbxBID. Has worked for me but I use classic MS Graph, not Modern Chart. SQL statement in RowSource can be simplified:

SELECT BoarID, CountOfCollection_Date, SumOfTubes, BiWeekly, [Year], Round([SumOfTubes]/[CountOfCollection_Date],2) AS Ave FROM GraphRaw WHERE BoarID=[tbxBoar_ID];

If you want to provide db for analysis, follow instructions at bottom of my post. Unfortunately, if you are using Modern Chart I won't be able to view it.