Making an editable Sub-Form based on cross tabed query

[Guest]

I am using Access 2000. Will some one please tell me how to make an editable
sub-form based on cross tab query. So that changes made in a cell will be
stored in table.


Here is the specimen data that I want to show in the sub-form:

ColumnA : ColumnB: ColumnC
1 : 1 : 10
1 : 2 : 20
1 : 3 : 30
2 : 1 : 40
2 : 2 : 50
2 : 3 : 60


I have to show Column A on Y-Axis and Column B on X-Axis. This will become a
matrix. Here, in this two dimensional sub-form, I have to show Column C
values.

Using cross tab query, I can only view the data in matrix form. But I do
want to make that sub-form editable. Changing value in any cell will be
stored in table.

- Imtiaz ([email protected])

 

[Douglas J. Steele]

A cross-tab query is never updatable. You'll either have to store the
results of the cross-tab query in a temporary table, update the temporary
table and then figure out some way to get the changes back to the original
table, or you'll have to use an unbound form (although unless you know the
maximum number of ColumnB values you're going to be dealing with, that will
be tricky)