I have to show Column A on Y-Axis and Column B on X-Axis. This will become a
2-dimensional data form. Here, in this two dimensional form, I have to show
Column C values.
I have to show Column A on Y-Axis and Column B on X-Axis. This will become a
2-dimensional data form. Here, in this two dimensional form, I have to show
Column C values.
Use the Crosstab Query Wizard to create a Crosstab query on this
table; display it in datasheet view in the subform.
It won't be updateable - if you want to be able to update the values
of C on this subform it will be a good bit more complex, especially if
there are variable numbers of different B values.
Along with the issue of making the sub-form editable. I also need to change
the contents of the sub form accordingly by changing some control on the
parent form.
e.g.; I have got a combo control on the parent form named "Year". On
changing the year value, I want to show respective records in editable
sub-form.
A crosstab query is NEVER updateable, and cannot be made updateable.
You'll need to either bind the Subform to a temporary table with a
"wide-flat" structure, and use VBA code to migrate the data from that
wide table into the normalized structure (and vice versa), or use an
unbound form with a grid of textboxes (or other controls) and - again
- use code to move data from the table to the form, and back from the
form into the table.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
