I have a pop up form that has the following SIMPLE code just to change the color of two fields based on the date.
If Me.[ExpDate] < Now() + 90 And Me.[ExpDate] > Now() Then
Me.[Training].BackColor = RGB(255, 255, 0)
Me.[ExpDate].BackColor = RGB(255, 255, 0)
ElseIf Me.[ExpDate] <...