title: Is there a way to create a Form in MS-Access without using a table?
body: <p>I want to show the results of a call to a webservice (several rows) in ms-Access. To do this I created a form with the defaultView = 1 (= continuous form).</p>
  
  <p>Now I wonder if I can use show results from the webservice directly in my form. This means without creating a table which I then select with the recordsource-property.</p>
  
  <p>Is there a way to show data a continuous-form in MS-Access without using a table?</p>
  
  <p>I tried to set the recordset by myself like this:</p>
  
  <pre><code>Private Sub Form_Load()
  
    Set m_Dataset = CurrentDb.OpenRecordset("Test", RecordsetTypeEnum.dbOpenDynamic)
    Call m_Dataset.AddNew
    m_Dataset("OutOfThinAir") = "Hallo"
    Set Me.Recordset = m_Dataset
  
  End Sub
  </code></pre>
  
  <p>But OpenRecordset raises the error "invalid argument".</p>
  
  <p>I also thought of setting the recordsource to a select statement without using a table name (In oracle this would be "Select ... from dual") but I did not find a working statement. "SELECT 1 from dual;" does definitely not work.</p>