Access: UPDATE column with values from another table
<p>I'm trying to Update column1 in table1 with values from column2 from table2 with a criteria in table2.
This is very confusing so here is my SQL code, maybe then you understand what I mean...</p>

<pre><code>Private Sub Button_Click()
Dim strSQL As String
strSQL = "UPDATE table1 SET column1 = table2.column2 WHERE table2.ID = 1"
CurrentDb.Execute strSQL
End Sub
</code></pre>

<p>This code isn't working as expected, so I need your help...</p>

<p>Thanks in advance!</p>