ControlSource

[Guest]

I want to store data that has been calculated. I am using the DateAdd
function I want to store the new date once it's been calculated but b/c I am
using the control source to perform this calculation in the form I can't
store the data. Can someone please tell me if there is a way to calculate and
store the formula.

for instance
DateAdd("m",ServiceInterval],[tblLog Subform].Form![ServiceDate)]
this is my formula and I want to store the date in the NextServiceDate
column of the service table.

please help.

 

[Allen Browne]

See:
Calculated Fields
at:
http://allenbrowne.com/casu-14.html

The article explains how (and when) to store a calculated result.