I am entering tasks into a task table from a form

So

something like

Date Task PersonID etc etc etc etc
10/10/2008 Blah 1

I have a bound form which allows me to add one record. However I want to allow the same task to be entered for multiple people based upon the data as entered in the form.

10/10/2008 Blah 1
10/10/2008 Blah 2
10/10/2008 Blah 3
10/10/2008 Blah 4
10/10/2008 Blah 5

Whats the best way of doing this. (I have a listbox on my form so multiple personIDs can be chosen.

When the correct number of records are added - a continuos form will popup, which allows slight amendments of the multiple records. - Again what would be the best method of capturing the record IDs to allow them to be edited.

I am using a SQL server backend - so maybe a stored procedure could add the mutiple records?

Ta la

Use a For I To list count having selected multiple records to add them to your table

Ta

Is there no simple SQL to copy a record n times to a table - then I could open it and loop thru making amendments?

Ta

Is there no simple SQL to copy a record n times to a table - then I could open it and loop thru making amendments?

Forget that - I'll just loop thru doing a insert statement n times - which is I guess what you meant.

Ta