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!