Problem getting Form values to display in Associated Table

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

Guest

I have created a series of expressions in a Form (creating various sums -- of
different field values). The values created by these expressions are the
visible in the Table. Subsequently, when I open the associated table, the
original field values are visible, but none of the values created by the
summing expressions are present or visible. So, the Form and the Table are
communicating, but certain fields (the expression fields) are not getting
their values from the form to the table. I'd really appreciate any ideas on
this issue. Thanks very much,
Jason T.
 
That's exactly how Access is designed to work.
If you can calculate the value in a field directly from other values in that
record, there's no need to store them - just recalculate on demand.
Besides, that way you never have to worry about updating the values stored
in calculated fields if some of the component values change - it's
automatic!
 
Back
Top