Command Button - Increase Data by One

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

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
 
Back
Top