title: VBA Access Where Clause with Form Date Values
body: <p>I'm trying to write a <code>DoCmd.RunSQL</code> with a <code>where</code> clause with date values passed through from a form.</p>
  
  <p>The code I've written runs without errors but returns 0 values because of this I think its a date formatting issue...</p>
  
  <pre><code>DoCmd.RunSQL ("SELECT [Field1], [Field2] INTO [tbl_recordset] FROM qry_1" _
   &amp; " WHERE (qry_1.Survey_Dt) &gt;= #" &amp; Format([Forms]![frm_Parameters]![txt_StartDate], "YYYY-MM-DD") &amp; "# ;")
  </code></pre>
  
  <p><code>qry1.Survey_Dt</code> is passed through from the SQL server in the default format (yyyy-mm-dd format), does Access reformat the data in the parent query?</p>
  
  <p>I've tried reformatting the dates in the parent query and the child query but with no success.</p>