I have a form with a sub form and I want the field on the main form to change color if the date is greater than today. The field on the main form changes when I scroll from one record to another.

I tried the following code but I get an error that the field is not recognizable.

Private Sub Form_Current()
If Me!TargetFundin gdate < Date Then
Me!TargetFundin gdate.BackColor = 255
Else
Me!TargetFundin gdate...