title: How to make a single Access form create multiple records
body: <p>I'm relatively new in using Access. </p>
  
  <p>I'm creating a database for questions and answers. Answers are stored in the answertable with the following fields: timestamp, question id, answer text, person id. Each record only contains one answer. </p>
  
  <p>Now, I'm looking for a way that lets me update/enter multiple records at the same time. For instance, the person  using the form should be able to fill all respondent's answers, then hit submit. If there were five questions, the result should be five records with only the field 'answer text' differing from the other four. </p>
  
  <p>I've searched on Stackoverflow but the only solutions that are given are in RoR. I'm experienced in VBA, but that's it. </p>
  
  <p>Any help would be greatly appreciated. Thanks. </p>