title: How do take the value from a combobox and use it to run an SQL query
body: <p>I am trying to take the value from a combo box (in this case 'cboFullName' located on form 'frmMasterNotebook') and cross reference it to table 'tblSearchEngine01' so that an update gets made to column 'query05contactselect' for all records where in column 'contact' the value matches to that selected by the combobox ('cboFullName').   Below is my code but I am getting a syntax error message.  </p>
  
  <pre><code>Private Sub cboFullName_AfterUpdate()
  
   st_sql = "UPDATE tblSearchEngine01, SET tblSearchEngine01.Query05ContactSelect = '1' WHERE (((tblSearchEngine01.[contact])=([forms]![frmmasternotebook]![cbofullname]))))"
              Application.DoCmd.RunSQL (st_sql)
  </code></pre>