Guys & Gals,

Here's hoping you'll be able to help me out.

Trying to create a couple of small forms with some subform query links. I decided that this particular form I was creating merited being shown as a Pivot Table.

I have managed to get through certain issues I had but I'm going to ask the questions anyway as I'm sure I've not used best practice.

  1. I couldn't find a good way of stipulating how the Pivot should be created, so I ran the form with the sub form, created the pivot, and then closed the form. The settings were retained - How should the pivot be created up front though?
  2. As above - I created the pivot, but now have the problem of stopping of finding a way of reverting the Pivot layout back to a "default" when the form is closed. any ideas?
  3. Once my input boxes are populated on the form, and a button is pressed the subform refreshes. How then can I export this subform Pivot to Excel?

Probably some very fundamental issues there - but if anyone can help I'd be very appreciative.

Thanks again

Wiggz aKa Craigy B