Directly edit Column Field value when in PivotTable form-view?

[Ronnie101]

I have a simple table consisting of a MainCategory column, a SubCategory column and a DataValue column.

The MainCategory and SubCategory values are not intended to be edited, but the DataValue values are required to be user-editable (one way or another).

I have been tasked with building a TreeView to organise this data so that the user can expand or contract the MainCategory as required, and within each of the expanded MainCategory nodes see the appropriate SubCategories as subnodes, and their respective DataValues within editable textboxes next to each subnode.

I have found that if I view the table in a form in PivotTable view mode (MainCategory and SubCategory placed in the left "Row" area and DataValue in the "Column Field" area, it does EXACTLY what I want - except that the DataValues are NOT editable.

It looks like they ought to be editable, since if you click on them a dark blue edit-style box appears around the value - but there is absolutely nothing in the Properties, etc, to make this box read/write.

Can anyone help? (Alternatively, if there is some sample Treeview code lying around somewhere, that would do just as well.)

Thanks!

 

[Ronnie101]

PS - I'm using Access 2003 under Windows XP