title: Inserting multiple rows to table - Access
body: <p>I have an Access application in which I need to do a 'mass-update'.</p>
  
  <p>I have a form on which I have a dropdown, a listbox, and a checkbox. I also have a Update button, and when the user clicks it, I want to insert rows into my table with the same value for the dropdown and checkbox fields in all the rows, but I want different values for each row depending on the list items that were selected.</p>
  
  <p>I know that multiple rows can be inserted into a table using the <code>UNION SELECT</code> statement, but how am I supposed to apply that with a listbox? </p>
  
  <p>Can anyone please help?</p>
  
  <p>Thanks in Advance</p>