title: How to show recordset data in Ms access subform
body: <p>How can i show the result of one SQL query in an Access Sub form control? I tried the below code</p>
  
  <pre><code>Dim db As DAO.Database
  Dim rs As DAO.Recordset
  Set db = CurrentDb
  Dim qry As String
  
  qry = "SELECT FirstName,Email FROM Customer" '
  Set rs = db.OpenRecordset(qry)
  
  Customer_enquiry_subform.Form.Recordset = rs
  </code></pre>
  
  <p>Where <code>Customer_enquiry_subform</code> is the name of my SubForm. I have only 2 columns in my Subform to show, FirstName,Email </p>
  
  <p>It is throwing me an error </p>
  
  <blockquote>
    <p>Run-time error 3251 :  Operation Not supported for this type of
    object.</p>
  </blockquote>
  
  <p>Can some one tell me what i am doing wrong ?</p>