title: Result of select query for setting value of update query does not work
body: <p>I have an update query in MS Access; for setting value of update query I have used a select query for which I am sure the result is unique, but I get an error </p>
  
  <pre><code>SET asbuilt_list.commented_sheet =
         Nz((SELECT [pages]
             FROM [tbl_transmittal_discipline_poi_max] AS T1
             WHERE (T1.[owner document number] = asbuilt_list.[doc])
               AND (T1.poi = "cmn" )), 0)
  </code></pre>
  
  <p>This is the error I get:</p>
  
  <blockquote>
    <p>operation must use an updateable query</p>
  </blockquote>
  
  <p>My update query is this:</p>
  
  <pre><code>UPDATE asbuilt_list
  INNER JOIN tbl_transmittal_discipline_poi_max ON asbuilt_list.doc = tbl_transmittal_discipline_poi_max.[owner document number]
  SET asbuilt_list.commented_sheet =
         Nz((SELECT [pages]
             FROM [tbl_transmittal_discipline_poi_max] AS T1
             WHERE (T1.[owner document number] = asbuilt_list.[doc])
               AND (T1.poi = "cmn" )), 0)
  WHERE 
      (((asbuilt_list.description ) NOT LIKE "*isometric*")
       AND ((asbuilt_list.doc) NOT LIKE "*ls*")
       AND ((asbuilt_list.discipline) &lt;&gt; "ppd"))
        OR ((( sbuilt_list.description) IS NULL)
            AND ((asbuilt_list.discipline) IS NULL));  
  </code></pre>