Date calculation from one field to store in another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frenchy - 28 Mar 2007 09:38 GMT

I have a table "Appraisals" with amongst others two fields, one called
Appraisal_Reminder and the other Appraisal_Due. In the input form I would
like for the Appraisal_Due to be the date in the Appraisal_reminder + 14 days
so that when the user input 01/03/2007 in the Appraisal_Reminder field the
Appraisal_Due field is populated with 14/03/2007 automatically and then the
focus go the next field.
I have come across some code which add date but I am a little stuck as the
syntax in my case would be DateAdd(day, 14, date) but instead of have a date
I would like it to be the value in the Appraisal_Reminder field.
Has anyone come across this and would be able to help with coding this?
Thank you for your reply.

Signature

frenchy

Reply to this Message

Allen Browne - 28 Mar 2007 10:36 GMT

In the AfterUpdate event procedure of the Appraisal_Date text box on your
form:

Me.[Appraisal_reminder] = DateAdd("d", 15, [Appraisal_Due])

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a table "Appraisals" with amongst others two fields, one called
> Appraisal_Reminder and the other Appraisal_Due. In the input form I would
[quoted text clipped - 10 lines]
> Has anyone come across this and would be able to help with coding this?
> Thank you for your reply.

Reply to this Message