title: Run time error 424 .. object required
body: <p>I am getting this error in Microsoft Access: </p>
  
  <blockquote>
    <p>runtime error 424 object required </p>
  </blockquote>
  
  <p>And below is the VBA code that I have used on the backend of a button: </p>
  
  <p>VBA Code</p>
  
  <pre><code>Private Sub Command87_Click()
  If Me.phase &lt;&gt; "" Then
      Me.lst_caseItems.RowSource = " " &amp; _
          "SELECT tbl_master.fld_masterID, " &amp; _
              "tbl_master.fld_masterActionNo AS ActionNumber, " &amp; _
              "tbl_master.fld_masterStudyActionNo AS StudyActionNo, tbl_master.fld_masterIssuedTo," &amp; _
              "tbl_master.fld_masterRev AS Rev, tbl_phases.fld_phase AS Phase, tbl_studies.fld_study AS Study, " &amp; _
          "FROM ((tbl_master LEFT JOIN tbl_studies ON tbl_master.fld_studyID = ' " &amp; tbl_studies.fld_studyID &amp; " ') LEFT JOIN tbl_phases ON tbl_master.fld_phaseID = ' " &amp; tbl_phases.fld_phaseID &amp; " ') LEFT JOIN tbl_locations ON tbl_master.fld_locationID = ' " &amp; tbl_locations.fld_locationID &amp; " ';"
  End If
  End Sub
  </code></pre>