Pivot table data source

[sub5]

Hi all,

stupid question...
I've searched high and low, a few times to avoid accusations of a "man-look"...

but how to I id what query/table/sql is providing data to a pivot table on a form?!

Thanks in advance.

 

[PHV]

Have you tried to play with the PivotTable.DataSource property ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[sub5]

Hi PHV, thanks for your reply, yea tried that and I get a 438 error object doesn't support method/property. RowSource returns blank (which I would expect from looking at the properties tab)

(nb - also want to auto refresh the pivot table from the form, basically when the form opens - I've searched the site, there are plenty of posts with the same question but few answers and the ones there don't seem to work for me - do you know how to do it? Have tried refresh, requery)

Thanks

 

[sub5]

Hi PHV, I am still falling over this, I just wondered if you had any other ideas. No problem if you don't.
Thanks sub5.