<div>
try this<br />
<br />
<br />
strSQL = &quot;UPDATE tbl_Actions SET tbl_Actions.Completed = 1 WHERE [CAPA#] = &quot;&nbsp;&amp; x<br />
<br />
if the field &quot;Completed&quot; is a Yes/No or Tue/False field, use this<br />
<br />
<br />
strSQL = &quot;UPDATE tbl_Actions SET tbl_Actions.Completed = -1 WHERE [CAPA#] = &quot;&nbsp;&amp; x
</div>


try this


strSQL = "UPDATE tbl_Actions SET tbl_Actions.Completed = 1 WHERE [CAPA#] = " & x

if the field "Completed" is a Yes/No or Tue/False field, use this


strSQL = "UPDATE tbl_Actions SET tbl_Actions.Completed = -1 WHERE [CAPA#] = " & x

<div>
<div class="content wysiwyg-content">
Dim strSQL As String<br />
Dim x As Integer<br />
x = Me.CAPA_Number<br />
strSQL = &quot;UPDATE tbl_Actions SET tbl_Actions.Completed = 1 &quot;&nbsp;&amp; &quot;&nbsp;WHERE [CAPA#] = x&quot;<br />
DoCmd.RunSQL strSQL<br />
<br />
I am sure this is very simple for an expert but my x is not seen as a variable, can anyone help woth the syntax please
</div>
</div>


Dim strSQL As String
Dim x As Integer
x = Me.CAPA_Number
strSQL = "UPDATE tbl_Actions SET tbl_Actions.Completed = 1 " & " WHERE [CAPA#] = x"
DoCmd.RunSQL strSQL

I am sure this is very simple for an expert but my x is not seen as a variable, can anyone help woth the syntax please

Update query syntax

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.