Detail Section Color Change

[Guest]

Using the following code, I cannot get the detail section to change back to
the original color, regardless of the text selected in the combo box. It
changed the first time I went back to the form. I'm using ElseIf because I
have other conditions on the After Update event of the TypeCombo box.

ElseIf Me.TypeCombo = "CONDITIONAL TEXT" Then
Me.Section(acDetail).BackColor = 8421440
End If

Any help is appreciated!
Phisaw

 

[fredg]

Using the following code, I cannot get the detail section to change back to
the original color, regardless of the text selected in the combo box. It
changed the first time I went back to the form. I'm using ElseIf because I
have other conditions on the After Update event of the TypeCombo box.

ElseIf Me.TypeCombo = "CONDITIONAL TEXT" Then
Me.Section(acDetail).BackColor = 8421440
End If

Any help is appreciated!
Phisaw

Your code changes the color of the section but you do not have any
code here that changes it back.

If ..... etc .....
Else
If Me.TypeCombo = "CONDITIONAL TEXT" Then
Me.Section(acDetail).BackColor = 8421440
Else
Me.Section(acDetail).BackColor = whatever color you want
End If
Else
continue with the rest of your code....

 

[Guest]

Thanks, Fred for the reply. The users have decided to go to separate form
with new color that doesn't change, but I will keep the code for future use.
Thanks again for all your help. Phisaw