title: Runtime error '3075' in VBA
body: <p>I know there are plenty of posts with the same title, but I couldn't find anything similar to my problem.</p>
  
  <p>I'm trying to update a record with SQL in VBA. In particular, my code goes to an excel file, extracts a value, asks the user for the ID of the record that needs to be updated, and then should procced to do the update. The thing is i tried running the same code without the user input, and works just fine, so the problem must be with the interpretation of the input. I checked that everything is a string but i don't know how to solve the problem.</p>
  
  <p>Here is the code I am using:</p>
  
  <pre><code>Dim query2 as string
  Dim myID as string
  myID = InputBox("Insert ID:")
  query2 = "UPDATE [Info test] " &amp; "SET RESULT = " &amp; var &amp; "WHERE ID =" &amp; myID
  DoCmd.RunSQL (query2)
  </code></pre>
  
  <p>In this case, var is a string, and is the value i fetch from the excel file.
  From various tests, i think the problem is with the last &amp; myID, like there is an apostrophe before the value stored by myID, but i don't know what to do about it, or if this is really the problem.</p>
  
  <p>Thanks to everybody who can help</p>