I am trying to update the background color of a field in my sub-form's parent form.
-------------
Private Sub Combo23_AfterUpdate()
If Me![Status] = "Pending: Waiting for Authorization" Then
Me.Parent.OverallStatus.BackColor = QBColor(6)
End If
End Sub
----------------
It works by updating the field, however, it is not just updating that particular parent field - it is updating the color on ALL records for that field. How do I make it exclusive to just changing the color of the parent field of THAT record?
Also, and less important - is there a color coding better for bright yellow?
-------------
Private Sub Combo23_AfterUpdate()
If Me![Status] = "Pending: Waiting for Authorization" Then
Me.Parent.OverallStatus.BackColor = QBColor(6)
End If
End Sub
----------------
It works by updating the field, however, it is not just updating that particular parent field - it is updating the color on ALL records for that field. How do I make it exclusive to just changing the color of the parent field of THAT record?
Also, and less important - is there a color coding better for bright yellow?