Display temporary calculated values in datasheet?

  • Thread starter Thread starter TK
  • Start date Start date
T

TK

I have a form in datasheet view that gets its initial
values from a view that includes calculated columns. As
the user makes changes, the calculated columns need to be
updated to reflect the new values, however, the edits
won't be written back to the source tables until edits to
the entire datasheet are complete.

I want to change the values for the calculated columns
through code, but Access knows these are calculated
columns, and I cannot figure out how (or where) to save
these values temporarily until the form is closed and the
data is committed to the source tables.

Is it possible to change an object's control source when
the form is open? Or should I create extra columns in the
recordsource that can store the temporary values?

Everything I have tried seems kludgey and I know there
must be an elegant approach for this. Someone please point
me towards the light!

Any help will be greatly appreciated.

(I am working with an ADP with an MSDE 2000 data source)


TIA,

Tom
 
I think I have resolved this:

In the form's Open event I create a temporary table based
on the view that had been the recordsource for the form.
The form is then bound to this temp table and all columns
can be edited in the form. Then I run an update query on
the form's exit and all is well.

It didn't seem so complicated today... a little sleep
and/or coffee is always a good idea.

TK
 
Back
Top