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.
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?
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?
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.