title: SQL Access Error - Syntax error in query expression
body: <p>What's wrong with SQL code below:</p>
  
  <pre><code>INSERT INTO tbl_HAMP_Actions ( Loan_ID, Action_ID, Event_User, Event_Time, Event_Station, Reason_ID )
  VALUES(3238, 3, 'CONTROL', Now(), 'CONTROL', (SELECT tbl_Reasons.Reason_ID
  FROM tbl_Reasons
  WHERE tbl_Reasons.Reason = 'Incorrect Information'));
  </code></pre>