Multi-select records from subform to create records in new table

[robtperk]

I need to create some new records based on main form data and a selection of records from a sub form. The main form and sub form have different sources. I wanted to show the source fields in the sub form along with a check box to allow the users to select individual records. The record source for the sub form contains >1000 records, so the user will first enter data in the main form, use filters to find the records he wants to 'assign' to the main form data, click those he selects, then click a command button in the main form to create the record(s) based on the main form data and the selected records from the sub form. The new records will be appended to a new table. Help is appreciated, especially if you have examples. TIA.

[June7]

Is this what you want to happen:

1. User selects records by checking a Yes/No field

2. Copy records checked yes, something like:
CurrentDb.Execute "INSERT INTO tablename SELECT <field list here> FROM sourcetablename WHERE Selected = True;"

3. Reset the Yes/No field back to No for all records:
CurrentDb.Execute "UPDATE sourcetablename SET Selected = False;"

[robtperk]

Thanks to June7. I added a select field to my tasks table, then cleared the value after I processed my records.