title: Access Report not Filtering when Others Are
body: <p>I have a form which allows the user to edit the properties of a filter via some combo boxes, then open a report. The report is opened with</p>
  
  <pre><code>DoCmd.OpenReport rptName, acViewReport, , whereClause, acWindowNormal
  'whereClause = "Building = '005'" for instance
  </code></pre>
  
  <p>Some reports open fine, by which I mean they populate with the filtered info. Others, however, even though they are based off the same in-house template, IGNORE the filter all together and display a report based on ALL data (not the filtered data).</p>
  
  <p>Why would a report ignore the filter? When I edit the reports in design mode after opening them with the form:</p>
  
  <pre><code>Working Report              |       Non Working Report
  Filter: Building = '005'    |       Filter:  
  Filter On Load: No          |      Filter On Load: No
  </code></pre>
  
  <p><strong>What could be causing the non-working report to not register the filter argument?</strong> There's no On Load VBA, nor any VBA, in these reports (except for an Export to PDF and a close button which is copy-paste for each report).</p>
  
  <p><strong>EDIT</strong>
  Should have checked before, this happens regardless of whether or not the query driving the report is empty (ie the filter is never applied to some reports, regardless of blankness)</p>
  
  <p>Not sure if the code will help, but:</p>
  
  <pre><code>Private Sub btnOpenSummary_Click()
    If IsNull(Me.cboSummary) Then
        MsgBox "Please select a building for the SUMMARY report."
        Exit Sub
    End If
    strCrit = "Building = '" &amp; Me.cboSummary &amp; "'"
    MsgBox strCrit
    survArray = getSurveyArray()
    For Each Survey In survArray
        DoCmd.OpenReport Survey, acViewReport, , strCrit, acWindowNormal
    Next Survey
    DoCmd.OpenReport "Total Summary", acViewReport, , , , Me.cboSummary
  End Sub
  </code></pre>