<div>
What are data types of varUpdateQTY, carPartID?<br />
You need not be so explicit in naming the table every time you mention a field in the table.<br />
sqlStr = &quot;UPDATE &quot;&nbsp;&amp; varTmpTableName1 &amp;&nbsp;&quot; SET &nbsp;[qtytopurchase] = &quot;&nbsp;&amp; varUpdateQty _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&nbsp;&quot; WHERE &nbsp;PartID)= &quot;&nbsp;&amp; varPartID<br />

</div>


What are data types of varUpdateQTY, carPartID?
You need not be so explicit in naming the table every time you mention a field in the table.
sqlStr = "UPDATE " & varTmpTableName1 & " SET  [qtytopurchase] = " & varUpdateQty _
                        & " WHERE  PartID)= " & varPartID


<div>
Thanks Cap! &nbsp;I think u are on a roll getting points off my syntax questions! &nbsp;LOL.
</div>


Thanks Cap!  I think u are on a roll getting points off my syntax questions!  LOL.

<div>
<div class="content wysiwyg-content">
I am trying to use an update query but cannot get the syntax correct. &nbsp;Please advise. &nbsp;This is obviously my hardest thing to grasp (SQL Query syntax with variables).<br />
<br />
For Each varItm In Me.lstVendorPartsList.Item<wbr />sSelected<br />
&nbsp; &nbsp; &nbsp; &nbsp; varPartID = Me.lstVendorPartsList.Item<wbr />Data(varIt<wbr />m)<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DoCmd.SetWarnings False<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dim sqlStr As String<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sqlStr = &quot;UPDATE &quot;&nbsp;&amp; varTmpTableName1 &amp;&nbsp;&quot; SET &quot;&nbsp;&amp; varTmpTableName1 &amp;&nbsp;&quot;.[qtytopurchase] = &quot;&nbsp;&amp; varUpdateQty _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&nbsp;&quot; WHERE (((&quot; &amp;&nbsp;varTmpTableName1 &amp;&nbsp;&quot;.PartID)= &quot;&nbsp;&amp; varPartID<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'MsgBox sqlStr<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DoCmd.RunSQL sqlStr<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DoCmd.SetWarnings True<br />
&nbsp; &nbsp; Next
</div>
</div>


I am trying to use an update query but cannot get the syntax correct.  Please advise.  This is obviously my hardest thing to grasp (SQL Query syntax with variables).

For Each varItm In Me.lstVendorPartsList.ItemsSelected
        varPartID = Me.lstVendorPartsList.ItemData(varItm)

            DoCmd.SetWarnings False
            Dim sqlStr As String
            sqlStr = "UPDATE " & varTmpTableName1 & " SET " & varTmpTableName1 & ".[qtytopurchase] = " & varUpdateQty _
                        & " WHERE (((" & varTmpTableName1 & ".PartID)= " & varPartID

                        
                 'MsgBox sqlStr
                DoCmd.RunSQL sqlStr
            DoCmd.SetWarnings True
    Next

update SQL Query in VBA Using Variables

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.