Saving calculated due dates to the table

[TLC]

How do I get the calculated due dates from a form to save in the table? The
form currently calculates the due date based on the referral date; however,
this date does not transfer back to the table. The calculated due date will
not change and I need this information to transfer back to the table in order
to run a tickler report. Thanks for any help offered.

 

[fredg]

How do I get the calculated due dates from a form to save in the table? The
form currently calculates the due date based on the referral date; however,
this date does not transfer back to the table. The calculated due date will
not change and I need this information to transfer back to the table in order
to run a tickler report. Thanks for any help offered.

No, you don't need to save the due date.
As long as you have the referral date saved, any time you need to
calculate the due date, calculate it, in a query, on a form or in a
report, using the same expression you are now using.

 

[John Vinson]

How do I get the calculated due dates from a form to save in the table? The
form currently calculates the due date based on the referral date; however,
this date does not transfer back to the table. The calculated due date will
not change and I need this information to transfer back to the table in order
to run a tickler report. Thanks for any help offered.

If you can calculate it on the Form, you can calculate it in exactly
the same way, just as easily, on the tickler report. There's no need
to save it.

John W. Vinson[MVP]