title: Popup box asking for parameter when using sql query in access forms
body: <p>I have a form with 3 things for my users to fill in: </p>
  
  <ol>
  <li><p>a textbox called <code>ProjectName</code></p></li>
  <li><p>two ActiveX control objects (Microsoft Time and Date picker Control 6.0) called <code>ProjStartDate</code> and <code>ProjEndDate</code> respectively</p></li>
  </ol>
  
  <p>After my users have entered either of the above, they can click on a button that will call requery on a list box object in the form which will display the filtered results.</p>
  
  <p>I have set the Row Source Type of the listbox to be "Table/Query" and its Row Source to be the below SQL query:</p>
  
  <pre><code>SELECT p.Title
  FROM Project AS p
  WHERE
    p.Title = [Forms]![Search by project]![ProjectName] 
    OR (p.StartDate &lt;= [Forms]![Search by project]![ProjStartDate]
        AND p.EndDate &gt;= [Forms]![Search by project]![ProjEndDate])
  ORDER BY
    p.ProjectId DESC; 
  </code></pre>
  
  <p>However, every time I enter the form, it will prompt me with a pop up box asking me for a parameter called <code>Forms!Search by project!ProjectName</code> , <code>Forms!Search by project!ProjStartDate</code> and <code>Forms!Search by project!ProjEndDate</code> . If I enter the parameter for, lets say project name correctly, the list box will display the correct filter results. </p>
  
  <p>Furthermore, even if I enter the correct keyword in the <code>ProjectName</code> textbox and requery, the parameter pop up box will still occur. Do anyone knows how to solve this issue? Thanks a lot in advance!</p>