title: MS ACCESS : Syntax error in FROM Clause
body: <p>I am trying to have a command button insert data into a new table and at the same time select a record and  update it. I will paste my code below and try to explain my problem.</p>
  
  <pre><code>CurrentDb.Execute " INSERT INTO Crew " _
      &amp; "(CrewName,KitNumber,ActionDate,ReturnDate) VALUES " _
      &amp; "('" &amp; Me.AssignCrew &amp; "', '" &amp; Me.AssignKit &amp; "','" &amp; Me.AssignDate &amp; "','');"
  Crew.Form.Requery
  
  strSQL = "SELECT * FROM Info 'WHERE InvKitNumber = '" &amp; Me.AssignKit &amp; "'"
  Set myR = db.OpenRecordset(strSQL)
  myR.Edit
  myR!Available = False
  myR.Update
  Set myR = Nothing
  
  Info.Form.Requery
  
  AssignKit = ""
  AssignKit.SetFocus
  </code></pre>
  
  <p>So everything works fine with the insert.  But when it gets past that I get the syntax error and the debugger highlights the "Set mrR = db.OpenRecordset(strSQL)".  I have fooled around with leaving out somethings but then I just get different problems.  Basically I am just trying to uncheck the checkbox in 'Info' where the unbound text (AssignKit) matches the same number in 'InvKitNumber'.  Is this the correct way to go about this problem?  I have tried a line of code using UPDATE but couldn't quite figure that out either due to "Too few parameters".  Thanks</p>