title: Adding multiple records to a table using radio buttons and check boxes, Access 2003
body: <p>I am building a database to track field personnel's on call schedule. Typically, the employee is on call for a full week, however, they do occasionally take specific days only. I have a form in Access 2003 that has an Option Group to indicate Full Week vs. Partial Week. If the form user selects "Partial Week" it enables a set of check boxes that let's the user specify specific days (Mon, Tue, Wed, etc). What I would like to be able to do is:</p>
  
  <p>If the user chooses "Full Week", the form will create 7 records, one for each day (Monday - Sunday) where all fields are the same, save for the "Day of the Week" field. However, if they choose "Partial Week", it should only create as many records as the user has chosen check boxes (so if they choose Monday and Tuesday, the form creates two records: one with "Day of the Week" equaling Monday and one with "Day of the Week" equaling Tuesday).</p>
  
  <p>Is this possible in any way/shape/form?</p>