how to set date field and have it show date field + year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Need help. I am using a legal form, I need to insert a date in one field and
set a statute date for a year later. I don't do any programing, this is all
new to me. Thank you, James
 
in the After Update event of your insert date:

Me.txtStatuteDate = DateAdd("yyyy", 1, Me.InsertDate)
 
Ok the one field is "DOA" date of accident and second field where I would
like the field to show "DOA" plus a year. So I would put "Me.txtStatuteDate
= DateAdd("yyyy", 1, Me.InsertDate)" So "insert date" = "DOA" Sorry
like I said this is new to me. Thanks again, James
 
That is correct.

MebeJames said:
Ok the one field is "DOA" date of accident and second field where I would
like the field to show "DOA" plus a year. So I would put "Me.txtStatuteDate
= DateAdd("yyyy", 1, Me.InsertDate)" So "insert date" = "DOA" Sorry
like I said this is new to me. Thanks again, James
Click to expand...
 
Sorry, I did not know you were using macros. I don't use them, so I don'
know how to help with this.
 
Back
Top