Auto-Update Pivot Tables

[NickDenyer]

Hi Guys,

Thanks for the help in advance!!!

I have a form on which there is a button. Clicking this button opens a pivot table that is on a form but opens in a default pivot table view. I've noticed that information on this pivot does not update, even when clicking refresh. The data contained in the Pivots are subject to change as they are based around dates, so it is important that the correct information is supplied day-to-day. The only way it will update the pivots is if I go through each individual record, located on another form, but this contains about 900+ records. Plus I need it to be user friendly for when I split the database.

At the moment, I have 'Me.Refresh' linked to the pivot, but it does nothing. Perhaps I have placed this event procedure in the wrong place? It is currently on both the 'on click' event in the button that opens the pivot, and in the form properties of the pivot itself under 'on current'.

Any ideas/suggestions/answers?

Thanks guys :-D

Nick