file update from a form to a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I need that after a calculation of a field result is copied into a table
I have the form1 and field1 and field2 from table1
I calculate fiel1*35 and I obtain a fieldx as a result but it would be
better if at same time it is copied into table1 field2.
 
Actually, if your calculation is producing the correct result it would be
best to just leave it as it is. There is no good reason to store a
calculation. It is there when you need to see it, which is all you need.
 
Yes, it is true but it would be fine if calculation can be store into the
table for later sum up of the new field.
 
If you performed the calculation in the first place you could do it again
later without first copying the result to a new field. However, if you
insist on doing so I suppose you could do something like bind a (hidden) text
box to the new field, and have an After Update event to pass the value from
the calculated control to the hidden text box. The After Update event would
be in all of the controls containing a value that is used in the calculation.
 
Back
Top