Command Button - Increase Data by One

[Guest]

Got a field called MerchantDOB, have a cmd, when I click it, I want it to
increase the date in the field for that record by one year. But not by
today's date.

Today's date is 8/11/2006

Example, 8/15/2006 is in the field, I want it to change to 8/15/2007, not
8/11/2007.

This is what I currently have as onclick event & it does this, what do I
modify?

Me.MerchantDOB = DateAdd("yyyy", 1, Date)

THANKS!!!

Curtis

 

[Guest]

Me.MerchantDOB = DateAdd("yyyy", 1, Me.MerchantDOB)

 

[Guest]

!!!!!!

Me.MerchantDOB = DateAdd("yyyy", 1, Me.MerchantDOB)