Vb Coding Help

[GarageConcepts]

Hey guys. I am trying to look up the date value from a field and, depending on that date, turn a button red to alert us the date is coming up. What is the best way to do that? The end goal is.... If any dates from the field are <= Date () +3 the i would like the button to change colors alerting us.

[ssanfu]

Is this for a form in Single Form view or Continuous Form view?

If the form is in Continuous Form view, all buttons will turn red. This is because the button is not bound to a specific record; it is just a control on the form.