Is it possible to create a datasheet form that works like a PivotTable

[slaterino]

Hi,
I have a table with three fields:
URN
session_ID
current

How can I create a form that has URN as the x-axis, session_ID as the y-axis and current as the data in between. URN will be a unique ID, there will be many session_ID's and current will be a yes/no field (preferably a checkbox).

I have seen that something similar can be done in PivotTable but the crucial thing is that it needs to be possible for the 'current' value to be changed. Is this possible?

Any suggestions?
Russ

[weekend00]

I could not figure out any simple way to do it.

[slaterino]

Yeah, it's such a shame. The PivotTable is so close to being perfect but without being able to edit the data in the table it makes it a little useless. I'm sure there must be another way though!

[weekend00]

Sure there are is other way. but maybe need lots of code involved.