title: How do I use a Checkbox on a form to add a record into a subform in Microsoft Office Access?
body: <p>I have a database for a carpet company. I have a form which enables the user to make a quote, including choosing the customer, etc. There is a also subform dealing with the products and extras, with quantities and unit prices. To state whether the user requires fitting there is a checkbox. When ticked I would like fitting to be added in the subform as one of the products. Products are normally manually chosen using a dropdown.</p>
  
  <p>Important properties are:<br>
  Form name: <strong>Orders</strong><br>
  Subform name: <strong>Order Details Subform</strong><br>
  Checkbox name: <strong>Fitting</strong><br>
  Field name for products: <strong>Product ID</strong><br>
  Subform linked to table: <strong>Order Details</strong><br>
  Form linked to table: <strong>Orders</strong></p>
  
  <p>I'm assuming VBA is needed, or the macro builder.</p>
  
  <p>Anyway thanks in advance!!</p>