title: Compile Error: Expected Case
body: <p>I have an event procedure of the form to <code>Execute</code> a series of 
  Append query statements to create the new related records. I am getting a "Compile Error: Expected Case" the <code>SELECT Inquiries.InquiryID</code> of the code is red. The exact code is pasted below.  </p>
  
  <pre class="lang-vb prettyprint-override"><code>Private Sub Form_AfterInsert()
     Dim db As DAO.Database
      Dim strSQL As String
      Set db = DBEngine(0)(0)
      strSQL = "INSERT INTO PreCallQuestionaireResidential ( InquiryID )"
      SELECT Inquiries.InquiryID
      FROM Inquiries
       db.Execute strSQL
      Set db = Nothing
  End Sub
  </code></pre>