I have a continuous form with feild [date needed]. I want to change the backcolor of this field if the system date is greater than the date needed feild. Below is the code I have placed on the Form_current event procedure.
Private Sub Form_Current()
If [DateNeeded] < VBA.Date Then
Me![DateNeeded].BackColor = RGB(0, 255, 0)
Else
Me![DateNeeded].BackColor = RGB(255, 255, 255)
End If
End Sub
However because it is a continuos form, all the date needed fields get changed to green. If I change to a single form and use the navigation buttons the code works. Is there a way to get it to work using a continuous form?
Private Sub Form_Current()
If [DateNeeded] < VBA.Date Then
Me![DateNeeded].BackColor = RGB(0, 255, 0)
Else
Me![DateNeeded].BackColor = RGB(255, 255, 255)
End If
End Sub
However because it is a continuos form, all the date needed fields get changed to green. If I change to a single form and use the navigation buttons the code works. Is there a way to get it to work using a continuous form?