Automatically Add Records

[SamTyco]

Hi,
I have a database which keeps track of projects and the various tasks associated with them. At present, there are 3 different types of projects that always have the same tasks. What I would like to do is that when someone creates a new project (form), the database would add records to the "Tasks" table corresponding to the necessary tasks for that type of project with values filled in based off the form.

For example, the form would contain:
Project Name: Awesome Stuff
Project Type: Type 1
Created By: John Doe

Upon clicking a "Add New Project" button, the database would add the following records to the "Tasks" table

Task ID Project Name Task Name Assigned To Start date
1 Awesome Stuff Open Task John Doe Date()
2 Awesome Stuff Order Parts Claire Orderer
3 Awesome Stuff Assemble Parts Pat Assembler
4 Awesome Stuff Ship Product Sam Shipper




The database would base what tasks it adds on the Project type.

Can anyone help me here?

Sam

[June7]

Requires code (I use only VBA) that would execute SQL INSERT statement for each record.

DoCmd.SetWarnings False
DoCmd.RunSQL "INSERT INTO ..."
'repeat DoCmd for each desired record
DoCmd.SetWarnings True