title: Command button to open report subject to criteria selected in combobox
body: <p>I have a form [Supervisors] with 2 comboboxes: supervisor, position.</p>
  
  <p>I have a report for employees with all kinds of information, among which are supervisor and position.  I want to make a command button that opens the report subject to whichever supervisor and position are chosen within the comboboxes.  This should be as simple as limiting in the WHERE statement, correct?  I used the Expression Builder to say:</p>
  
  <pre><code>Where Condition = [position] Like [Forms]![Supervisors]![PositionCombo]
                     AND [sup] Like [Forms]![Supervisors]![SupervisorCombo]
  </code></pre>
  
  <p>Yet when I click the button I get "The Microsoft Access database engine does not recognize '[Forms]![Supervisors]![PositionCombo]' as a valid field name or expression."  How do I tell Access to use the combobox values as limiting criteria?</p>
  
  <p>I don't know VBA, though I do plan to learn.  If possible, I would like to accomplish this without needing VBA.</p>