MS Access Pivotchart code

[grgimpy]

I have a pivotchart in a tab in my main form. First question: Is there a way to display only a certain number of the most recent records? For example, to limit the pivotchart to displaying only the 20 most recent values. The values have both a time and ID tag on them if that helps.

For my second question: Is there a way to automatically update the pivot chart as the query is also updated? When I enter data into a form in one of my tabs, I'd like the pivotcharts to also update at the same time. Currently, I have to close and re-open the form to update the pivotcharts.

Thanks

[Beatrice]

I have a pivotchart in a tab in my main form. First question: Is there a way to display only a certain number of the most recent records? For example, to limit the pivotchart to displaying only the 20 most recent values. The values have both a time and ID tag on them if that helps.

For my second question: Is there a way to automatically update the pivot chart as the query is also updated? When I enter data into a form in one of my tabs, I'd like the pivotcharts to also update at the same time. Currently, I have to close and re-open the form to update the pivotcharts.

Thanks

Frankly speaking I don't know if it works for pivot chart, but works for chart:
1) Design view, double click on the chart
2) right button click--> properties
3) Data folder, Row Source
SELECT TOP n instruction.

Bea