Access 2013: Use DateAdd to calculate based on button click

[Magnolia15]

Creating a database to track training. I have a form in which an original certification date is entered. From that date, I need to add 1, 2, or 3 years to determine the due date for re-certification (a separate field) based on the button that is clicked ("1 year", "2 year", or "3 Year".)

[Seth Schrock]

Here is a link to the description of the DateAdd() Function.

[Magnolia15]

thanks for the reply Seth. I have that info, but it doesn't work. Not sure if I am putting it in the right location or not. I tried putting it in the "On click"for the button, but I get an error about it being a macro:

[Re-Certification_Date]= DateAdd ("yyyy",1,[Certification_Date])

[Seth Schrock]

Are you doing this in code or in a macro? I would highly recommend using code and not a macro.

Also, please provide the exact error message along with the number if provided.

[Magnolia15]

I had done this in the "Property sheet". I used Access on a regular basis, a hundred years ago, but have been away from it for so long I think I have forgotten everything, lol.

The Exact Error is:
Microsoft Access cannot find the object '[Re-Certification_Date]= DateAdd ("yyyy",1,[Certification_Date]).'

If '[Re-Certification_Date]= DateAdd ("yyyy",1,[Certification_Date])' is a new macro or macro group, make sure you have saved it and that you have typed its name correctly.

There is no number associated with the error.

Thanks again!

[Seth Schrock]

If you are doing it in the property sheet, then you need to remove everything to the left of the equals sign. If you are wanting to do it in the button's OnClick event, then you will need to do something like the following:

Me.ControlName= DateAdd ("yyyy",1,[Certification_Date]) 

[Magnolia15]

You're Awesome Seth! I had forgotten all about "Me."

I just did it in the "Event Procedure" for the Button "OnClick" event and voila!!