single form to create multiple records in the same table

[WalterP34]

I've gotten some great tips/answers from this forum, so thanks to all the members who have given their time to the cause.
I do have a problem that I couldn't find a particular answer for.

I am creating a contacts database. I have a 'contacts' table and a 'tasks' table. The 'contacts' table has the standard info for each one of my contacts.

The 'tasks' table has fields for the task info plus a related field 'CompanyName' that's linked to the 'contacts' table.




Here is my question.

I would like to create a single form that will create multiple records in the task table by allowing me to select more than 'CompanyName' field at the bottom of the form. I'm assuming that would best be handled by a combo box that allows multiple selections.


I've only gotten so far with this. The only thing I've been able to do is create a form that puts multiple company names separated by a comma in the 'CompanyName' Field in the 'tasks' table in only one record and not a record for each separate 'CompanyName'.
Here is the output I've been getting:

'1'---'task1'---'company1,company3,company7,company12'---'taskdescription1'----'completeddate'


And here is the output I'm trying to accomplish:

'1'---'task1'---'company1'---'taskdescription1'----'completeddate'
'2'---'task1'---'company3'---'taskdescription1'----'completeddate'
'3'---'task1'---'company7'---'taskdescription1'----'completeddate'
'4'---'task1'---'company12'---'taskdescription1'----'completeddate'



The reason why I need them separated into different records is because down the road they will have different completed dates, priority levels, notes, etc.

And as you see above I sometimes don't need to assign a task to every company. That's why I thought a combo-box that allowed multiple selections via check-boxes might be the best way to go.

Let me know if you need me to relay any more info. I'm not sure how well I explained my situation.

Any help would be greatly appreciated!

Thanks!

[pbaldy]

Would this work for you?

http://www.baldyweb.com/MultiselectAppend.htm

[WalterP34]

Thanks Paul!!
I'll give it a shot. I'll let you know if I can get that code integrated into my DB.

[pbaldy]

No problem; post back if you get stuck. Welcome to the site by the way!