Update Field Based on Value Selected

[spudracer]

I've got a form, with an option group.

What I'm trying to do is update a particular date based on whichever value is selected. If the value = 1, it shouldn't do anything, but if the value = 2, then it should return next year's date.

I've tried implementing this code, but for some reason, it's just not working right.

Any quick coders out there willing to help?

 

[boblarson]

Are slow coders eligible to reply?

( by the way, posting the code you have might be easier than trying to do it all up from scratch)

 

[spudracer]

Are slow coders eligible to reply?

But of course.

Here's what I have, but keep in mind, I'm no expert.

If Me.Report_Status.Value = 2 Then Me.Closeout_of_Last_Report = Me.CODLR
Else Me.Closeout_of_Last_Report = Me.CODLR
End If

This is my first attempt at writing code from scratch. Be gentle.

 

[boblarson]

So, if the names are as shown (with the underscores) then it looks almost there. I am assuming that Me.CODLR is a date field?

If so, then -

If Me.Report_Status.Value = 2 Then 
   Me.Closeout_of_Last_Report = DateAdd("yyyy", 1, Me.CODLR)
Else 
   Me.Closeout_of_Last_Report = Me.CODLR
End If

 

[spudracer]

Thank you!!