title: Textbox_AfterUpdate not working with another control
body: <p>Why I can't change value of another control in access form in afterupdate function?</p>
  
  <pre><code>    Private Sub cNPSrate_AfterUpdate() 'Form_new_opinion_in!
  If Not IsNull(cNPSRate) Then
      Select Case cNPSRate
          Case 1 To 6
              cNPSRate.BackColor = RGB(255, 0, 0) And cSegmentNPS.Text = "KRYTYK"
          Case 7 To 8
              cNPSRate.BackColor = RGB(255, 255, 0) And cSegmentNPS.Text = "NEUTRALNY"
          Case 9 To 10
              cNPSRate.BackColor = RGB(0, 255, 0) And cSegmentNPS.Text = "PROMOTOR"
      End Select
  Else
  cNPSRate.BackColor = RGB(255, 255, 255) And cSegmentNPS.Text = Null
  End If
  End Sub
  </code></pre>
  
  <p>The code works if I remove <code>And cSegmentNPS.Text</code>. Can't I use another control in this function or I make some mistake?</p>
  
  <p>cNPSRate and cSegmentNPS are TEXTBOXes</p>