Pivot style read/write in forms

[Mr. Smith]

Hi.

I want to try to do this in a form:

Load data into a pivotstyle layout.

Let user change values and save values down to the pivottable source.



I have trouble finding a way to let users edit data in pivotstyle layout,
and save it back to the database.



I've even thought about building it from scratch with hiding/showing text
boxes, and move them around (up/down) to simulate expand/collapse.



The scenario is 28 rows in 8 columns, where the 28 rows should be summed up
around 6 total groups.



Is there a way to do this efficient in Access 2007 or will I have to set up
224 text boxes and build a sophisticated TopValue generator that will be
set the TopValue on the text boxes, based on a "expand/collapse" icon....





ANY hints appreciated.....



Kind regards

Mr. Smith

 

[Mr. Smith]

DStegon
Thank you so much for spending your time on my issue, so quickly. I really
appreciate it.

I'll look into your approach which looks very thorough and sophisticated.

Thanks a lot!

Kind regards
Mr. Smith