title: Is there a better way in writing a where clause in access vba
body: <p>Here is a little brain teaser!</p>
  
  <p>I have a query that has at least 3 different where clauses. Instead of writing an elaborate if statement to test every single possible outcome, I am wondering if there is a simpler way of doing it!</p>
  
  <p>These 3 clauses are chosen from drop down menus that have at least 3 x different values including an "ALL" option.</p>
  
  <p>I hope you guys are starting to se my issue...</p>
  
  <p>so if I have:</p>
  
  <pre><code>SELECT * FROM tabe1 WHERE col1 = combo1Value AND col2 = combo2Value AND col3 = combo3Value
  </code></pre>
  
  <p>USER decides to select the following:</p>
  
  <ul>
  <li>combo1: All </li>
  <li>combo2: item (an option that is not all) </li>
  <li>combo3: item (an option that is not all)</li>
  </ul>
  
  <p>so now is there a way to re-write my query: </p>
  
  <pre><code>WHERE col1 = * AND col2 = combo2value AND col3 = combo3value
  </code></pre>
  
  <p>or I have no choice but to write a big if-statement???</p>