title: What is the syntax for referring to a combobox on a form in vba for access?
body: <p>Here is what I've tried. What is wrong with this syntax. When I run this code I get a parameter value error message after selecting a value in combo52.</p>
  
  <pre><code>Private Sub Combo52_AfterUpdate()
  
  With Forms("UserForm").Combo56
      If IsNull(Forms("UserForm").Combo52) Then
          .RowSource = ""
      Else
          .RowSource = "SELECT [PayGroupCountryDesc] " &amp; _
                       "FROM HRBI " &amp; _
                       "WHERE [PayGroupRegionCode]=" &amp; Forms("UserForm").Combo52
      End If
      Call .Requery
  End With
  
  End Sub
  </code></pre>