Help with charts

[Andrew]

I have a Form "Accounts" and a subform "Transactions", and
another form with a Chart that shows some info
from "Transactions". Is there a way to filter the chart to
only show data on the form, and subform that I am
currently on, and not all the data? or would it be better
to print to excell, and if so, were do I find out how to
do that?

Thanks Andrew

 

[Eric Cardenas]

| I have a Form "Accounts" and a subform "Transactions", and
| another form with a Chart that shows some info
| from "Transactions". Is there a way to filter the chart to
| only show data on the form, and subform that I am
| currently on, and not all the data? or would it be better
| to print to excell, and if so, were do I find out how to
| do that?
|
| Thanks Andrew
-----------
Hi Andrew,

Yes this is possible. You will need to specify a parameter query for the
recordsource of your chart. The parameter in the query will point to a
control within your form. You also need to requery the chart whenever you
move from record to record within the main form.

Hope this helps,