title: Access multi selection list box as a criteria to INSERT, UPDATE OR DELETE records from a table
body: <p>For a database with this schema (a product may belong to one or more categories):</p>
  
  <pre><code>Item_category(product, category_name)
  Category(category_name)
  </code></pre>
  
  <p>Will it be possible for me to build a multi-selection list box (List box data source from the Category relation) using an Access form and then highlighting the categories that the product belongs to (by querying the Item_category table), and at the same time letting users select new categories or deselect highlighted categories so that when an "Update" button is pressed, VBA code will automatically determine either <code>INSERT, UPDATE or DELETE</code> queries are needed to update the <code>Item_category</code> table?</p>
  
  <p>How can I do that? Thanks!</p>