title: (Error 3071) Access
body: <p>I'm trying to search for the Course ID by checking the the faculty ID and Course ID in my Course table. Its a simple query but when launched I receive a</p>
  
  <p>(This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables. (Error 3071)</p>
  
  <p>The VB script I'm using looks like this.</p>
  
  <pre><code>Private Sub Course_ID_DblClick(Cancel As Integer)
  
  Dim x As Integer
  
  Dim y As String
  
  Dim z As Integer
  
  x = Me.Faculty_ID.Value
  
  Me.Course_ID.RowSource = "SELECT Course.[Course ID] FROM Course WHERE Course.[Course Name]=['Course']AND Course.[Faculty ID]='" &amp; x &amp; "'"
  
  End Sub
  </code></pre>