Formula in a field

[denise]

I have a field that in the control source I put a
formula. The answer to that formula shows up on the form
but not in the table. How do I get that answer to show up
in the table?

Thank you.

Denise

 

[Con Giacomini]

Generally there is no reason to update a field in the table with the results
of a calculation. Better to enter the formula in a query where the result is
available in the query or the form or a report. If your requirements are
such that the result MUST be in the table, use a SetValue macro to set the
expression.

Con Giacomini

 

[Denise]

Thank you, I will try that. The reason I thought it
should go back into the table is that later in the form, I
use that answer in another formula and could not do this
as the table was blank.

 

[Rick Brandt]

Thank you, I will try that. The reason I thought it
should go back into the table is that later in the form, I
use that answer in another formula and could not do this
as the table was blank.

So use a query instead of the table and put the calculation in the query.