Access 2007 Form information not appearing in associated Table

[MDS_frustrated]

Have created various expressions in different fields of a Form. The
expressions function correctly in the Form, outputing the correct
information. This information in the Form fields do NOT appear in the Table
from which the Form was created. If the expressions in the Form fields are
removed and the data inserted manually in these fields, the data then appears
as it should in the Table as it does in the Form. Another strange thing
occurs when I use the same Table to generate a Split Form, as in this case,
all the datta appears in the Table half of the Split Form, but not in the
orignal Table from which the Split Form was generated. Could anyone please
help as I tried all options - re-generating the Form and Table, with no
success.

 

[Rick Brandt]

Have created various expressions in different fields of a Form. The
expressions function correctly in the Form, outputing the correct
information. This information in the Form fields do NOT appear in the
Table from which the Form was created. If the expressions in the Form
fields are removed and the data inserted manually in these fields, the
data then appears as it should in the Table as it does in the Form.
Another strange thing occurs when I use the same Table to generate a
Split Form, as in this case, all the datta appears in the Table half of
the Split Form, but not in the orignal Table from which the Split Form
was generated. Could anyone please help as I tried all options -
re-generating the Form and Table, with no success.

Controls on forms are either bound to fields or to expressions. Only
controls bound directly to fields have their data written to the table.

Think of it this way. If the ControlSource property is defined as "what
field does my data go to" then a ControlSource that is not the name of a
field has nowhere to go.

The good news is that data based on expressions are not supposed to be
stored in your table anyway. Just use the expressions any place you need
them and delete those fields from your table as you don't need them.

 

[Gina Whipp]

This question was asked and answered... and so you don't have to go looking
for it...

Access is working correctly. A calculated result is NOT stored in a
table. Why would you want it to? That resulting value might be correct
today, but it will certainly be incorrect tomorrow. Besides, using
your expression, into which field should Access store the value even
if it could?

Instead of trying to store that value, anytime you need the result of
that calculation, re-calculate it, either on the form or report, or in
a query.

By the way, your expression could cause confusion further down the
road. In Access, -1 is True (not 1), so someone reading your code in
the future may very well be confused when trying to further use the
calculated results.