title: Open Report Use Three Combobox Filter
body: <p>I have 3 combobox to filter data, then i want to open in command button to print preview..
  Problems I have if i used 2 combobox it works but when i used three combobox the report is blank...there's any problems with the code?? here's the code i used :</p>
  
  <pre><code>Dim strWhereCondition As String
  strWhereCondition = "[month] = '" &amp; Me.cbmonth.Value _
                      &amp; "' and [Works] = '" &amp; Me.cbwork.Value _
                      &amp; "' and [Works] = '" &amp; Me.cbwork2.Value &amp; "'"
  
  Debug.Print strWhereCondition
  DoCmd.OpenReport "Month List", View:=acViewPreview, _
  WhereCondition:=strWhereCondition
  </code></pre>
  
  <p>and the requery for my form</p>
  
  <pre><code>SELECT *
  FROM MyTable 
  WHERE (month = Forms!nameForm!cbmonth
  OR Forms!MeForm!cbwork IS NULL)
  And (works = Forms!nameForm!cbwork
  OR Forms!nameForm!cbwork IS NULL)
  AND (works = Forms!nameForm!cbwork2
  OR Forms!nameForm!cbwork2 IS NULL);
  </code></pre>
  
  <p>can anyone help?</p>