title: Setting the Record Source of a subform in Access
body: <pre><code>Dim newRS
  newRS = "SELECT DISTINCT [Grp_ID], [Group_Name], [Group_NPI] FROM [GROUP]"
  Forms!loclistingfrm!LocationListSubFrm.RecordSource = newRS
  </code></pre>
  
  <p>When I look at the LocationListSubFrm sub form in Design View, there is no Record Source property. However, when I access it directly from the objects pane I can see it.</p>
  
  <p>Is the fact that it's a subform preventing me from changing the record source? The same subform is recycled throughout my application, so I can't really edit it at the source.</p>