Hello Guys,
I am trying to set a field 1 or 2 years out from another date (another field)and I used the DateAdd function but it is giving me an error Error 438 - Object doesn't support this property or method
Here is my code:
Private Sub SetDate_Click()
Dim NewDate As Date
NewDate = DateAdd("y", 1, Me.Expires) 'Me.Expires is the field with old date
SetDate = Me.NewExp
End Sub
What am I doing wrong? :banghead:
Thank you
I am trying to set a field 1 or 2 years out from another date (another field)and I used the DateAdd function but it is giving me an error Error 438 - Object doesn't support this property or method
Here is my code:
Private Sub SetDate_Click()
Dim NewDate As Date
NewDate = DateAdd("y", 1, Me.Expires) 'Me.Expires is the field with old date
SetDate = Me.NewExp
End Sub
What am I doing wrong? :banghead:
Thank you