title: Writing json response to a recordset in MS Access VBA
body: <p>I have a Json response from an API that returns a list of customers from the database I am querying.</p>
  
  <p>I need to display these customers (usually 4-5 customers, outlier could be 50) on a form for the user to select which one to save to the local database.</p>
  
  <p>This is the second API I am using, so i already have a table with
  Firstname
  Lastname
  Address
  Suburb</p>
  
  <p>My previous API was a SQL query so I just created a DAO recordset and then set the .recordset of the form.</p>
  
  <p>If I have a loop of patient details to record.. how can i put this into a recordset (DAO or ADO) and then
  use this to fill the form?</p>
  
  <p>The other option is just SQL update a local TEMP table.. which is fine but I wanted to know if there was a 'virtual list' way I can build this recordset?
  (And would this even be a good idea?)</p>