title: Access ListBox: Where condition issue
body: <p>I'm having an issue getting a list box to work.  The list itself refers to a table that contains the names of employees (A field named [Techs]).  This table is used to populate a 'master' table that contains tasks assigned to those employees (field: [Responsible])</p>
  
  <p>The aim here is to make it so an employee can be added to the table and in turn the list and all associated data will be updated with that name, but that tasks can be queried against the name itself, without a user having to design a new query every time.  I set up a query with everyone's name and their assigned tasks.  Then I made the list box.  I want it to run the query where the name matches what name the user clicks on.</p>
  
  <p>This is my where condition in the macro:</p>
  
  <pre><code>[Techs]=[Forms]![FindbyName]![Responsible]
  </code></pre>
  
  <p>I'm getting the dialogue that shows the first clause of WHERE at the top and a search box at the bottom.</p>