Updating recordset

  • Thread starter Thread starter Chad
  • Start date Start date
C

Chad

I have created a crosstab query and would like to link it
to a form to have users be able to update the data in a
specific table. Is this possible?

Whenever I try to enter in value it says that the
recordset is not updatable.

Thanks in advance,
Chad
 
Hi,

Indeed, if you would just change the result of the sum, without changing
its elements making it, next time you would ask for the sum, it will revert
back to what the elements making it would result into. No use. In general,
you should detect the group (line, record) and the pivot (where fieldname=
value), to find what original records are involved, to allow the user to
edit them, the "elements". Alternatively, if you just want the result and
the possibilities to edit it (which is, after all, a possible scenario too),
create a new table from the crosstab. The new table is editable, evidently.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top