Format a date out 1 year 2

[bigdogtech]

Trying to have a start date of Ex: 1/06/06 and have a end date of 1/6/07. I want it so when you enter in the start date a field populates with a end date one year later.

 

[rjoubert]

In the On Exit event of your start date field, add the following line of code...

Me.EndDateField.Value = DateAdd("yyyy", 1, CDate(Me.StartDateField.Value))

 

[bigdogtech]

Tried that bt it says can't find macr, do I need to create a macro for it?

 

[barny2006]

i think it should be:
Me!EndDateField.Value =
DateAdd("yyyy", 1, CDate(Me!StartDateField.Value))