Charts

[Zelgrath]

Is there a way to link the tittle and axis label fields of
a chart object to controls on a form?
Is there a way to change a chart record source from
controls on a form? For example: Can I pick number vs
name, hit a button and show a chart? And then close that
chart, change name to year on a form, click the button
again and see a chart of number vs year? I want to avoid
making a large number of premade charts.

 

[Duane Hookom]

One method is to base the chart on a saved query. This is the Row Source
property of the query. You can then modify the SQL of the saved query and
then open the report. The chart will reflect the new SQL.