If date is enter then this feild is +12 months

[Starcraft1535]

What im trying to do is create a form that allows fro a date to be enter then automatically enter a date 12 months later in other field.

Fields are:

Certified date: Date input
Next Eval: Auto Date 12+ months from Cert date.

 

[Starcraft1535]

Also if Cert date is blank then next eval = blank

 

[Starcraft1535]

I have tried adding this to the default value =DateAdd("m",12,[Last Eval]) and its not populating the date.

 

[Micron]

Don't know if this is conducive to your data types, but I would use the AfterUpdate event for the first control to calculate the date in the second control.
In between the sub/end sub lines, you could put:

If IsDate(Me.1stControlName) Then Me.2ndControlName = DateAdd("yyyy", 1, Me.Text1stControlName)

 

[Starcraft1535]

Don't know if this is conducive to your data types, but I would use the AfterUpdate event for the first control to calculate the date in the second control.
In between the sub/end sub lines, you could put:

If IsDate(Me.1stControlName) Then Me.2ndControlName = DateAdd("yyyy", 1, Me.Text1stControlName)

Im getting syntax error when putting in If IsDate(Me.LastEval) Then Me.NextEval = DateAdd("yyyy", 1, Me.LastEval)

 

[Micron]

Well, at least you're not getting a 'data type mismatch' error! What you posted looks correct, so post the rest of the event code and indicate the line on which the error occurs. I tested before posting and it worked for me.

 

[Starcraft1535]

Got it working thank you so much.