title: How I can change Combo Box value from another Combo Box using VBA?
body: <p>I'm trying to change combo box value based on other combo box selection. 
  Please see below the code:</p>
  
  <pre><code> Private Sub combo1_AfterUpdate()
  
  
  
        If (Me.combo1.Value = "MHE") Then
          Me.Combo2.Value = "SELECT * FROM Table1"
  
        End If
  
   End Sub
  </code></pre>