PIVOT TABLE FORM Question

[Sdaddy]

Help!!!

I have built a pivot table form in access 2000. Basically, it is used to track network outages by state on a real time basis. Users input tickets and related information.

Is there anyway to automatically refresh the pivot table form when users input new ticket information?

I certainly would prefer to use the 2002-2003 format and create a pivot table form out of the pivot table view , but the users only have office 2000.

I just got office 2003 and if there is a way to create something in 03 that is backwards compatible I'm game for that as well..

As always---Thank you in advance oh wise ones

 

[Sdaddy]

As a follow up.. Is there a way to create a toolbar on the form itself that would allow the user to hit the refresh button. I would want the toolbar to be bound to the form.