title: Access SELECT Statement and Hard coded Value
body: <p>Here is my VB SQL statement that is applied to the rowsource of an unbound list box on Form_Current:</p>
  
  <pre><code>SelectionSQL = "SELECT tbl_Patches_Cisco_SAs_Applicability.PatchID, tbl_Patches_Cisco_SAs_Applicability.OS 
        FROM tbl_Patches_Cisco_SAs_Applicability 
        WHERE (((tbl_Patches_Cisco_SAs_Applicability.PatchID)=[Forms]![Patch_Management_Cisco_Stage2]![Publication_ID]));"
  </code></pre>
  
  <p>It works great, the only problem is that I want the rowsource to include the hardcoded value of "NA", without having to create an associated record. Is this possible and how? i.e. to somehow add NA to the rowsource?</p>