Problem getting Form values to display in Associated Table

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.
 
M

MacDermott

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top