https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/40690.aspxFri, 17 Apr 2009 15:03:04 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:40690Wheels0https://www.infopathdev.com:443/forums/thread/40690.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=40690<p>Good morning all.</p> <p>I have the following code, but I am coming up with an error in my FROM statement.</p> <p>Sub CTRL10_7_OnClick(eventObj)<br />&#39; Submit Button<br />Dim strSQL, MyConn<br />&#39; Submit the form to add the new record<br />Set MyConn = CreateObject(&quot;ADODB.Connection&quot;)<br />MyConn.Open &quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\c9dpr\Desktop\GC100 Backend.mdb&quot;<br />StoreFields<br />XDocument.UI.Alert(Lockbox)<br />&#39;SQL statement to run apend query<br />strSQL = &quot;&quot;<br />strSQL = strSQL &amp; &quot;INSERT INTO tbl_GC100 (Lockbox, [Cash Deposit Date], [Batch Number])&quot;<br />strSQL = strSQL &amp; &quot; SELECT @Lockbox, @Cash_Deposit_Date, @Batch_Number&quot;<br />strSQL = strSQL &amp; &quot; FROM XDocument.DOM.selectSingleNode(&#39;dfs:myFields/dfs:dataFields/d:tbl_GC100&#39;)&quot;<br />XDocument.UI.Alert(strSQL)</p> <p>MyConn.Execute strSQL<br />MyConn.Close<br /><br />End Sub</p> <p>Any assistance would be greatly appreciated.</p> <p>&nbsp;Thank you, WHEELS</p> <p>&nbsp;</p>