Changing background by code

[Steve Voorhees]

Hi Steve,

Try this:

Private Sub Toggle0_Click()
If Toggle0.Value = -1 Then
Me.Detail.BackColor = vbRed
Else
Me.Detail.BackColor = 13056
End If
End Sub

This worked GREAT. However, I am stuck on something else with this. If you
went back into the record to look at it or change something, the background
it not changing to the new color, depending on what Toggle button is selected
as.
How would I have it check the Toggle, and do the update when a record that
was already entered was opened?

 

[tina]

try running the If statement in the form's Current event also.

hth