Pivotchart codes

[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

 

[AKMonkeyboy]

Couldn't you base your pivotchart on a query, and then limit the number of records using the query properties? Choose the top 20 records, then use the sorting area of your qurey to get the top 20 or bottom 20.

Give a man a fish, and you feed him for a day.
Teach a man to fish, and you feed
him for life.
Send a man to Tek-Tips and the poor sap can find out how to fish on his own, and learn more by doing it.