Inserting Multiple Records

[xixor]

I work for a nonprofit organization that allows individuals to sponsor children overseas. Some of these sponsors decide to become volunteers and speak at their church, university, or other event to find new sponsors. I am building an access 2000 database to store the results of these events.

I have a volunteers table with each person's name, contact info, and an id number. I then have a sponsorships table with the following fields:
id
fk_volunteerId (relationship defined)
date
sponsorName (the person who agreed to sponsor because of the presentation)
eventType (combo box with 5 set types)

Sometimes we will have nearly a hundred sponsorships come out of a single event, and I need a way for a nontechnical user to add sponsorships in bulk (a form basically), but I do not know any VB. Is there a built in function that I can use to do this or will I have to use VB? What I'm looking to do is build a form where the user specifies a volunteerId, an eventType, the event date, and the number of new records to be added and it will automatically insert that many records. (The sponsorName is not necessary in this case, if you were wondering.)

Thanks in advance!

[PianoMan64]

To answer your question,

Yes, you will need to write some VBA code to make the functionality that you're speaking of work the way you wish.

Normally what I would do is create a form that also has the list of Volunteers, then you would select the all the volunteers for that event, and then click add. This will then associate the volunteers to that event. This way there isn't a great deal of input that has to happen for each event.

If you're want a more specific answers, please include table structure, queries used, form names, control names on the form that are used, and any other detail that would be important to create what you're asking.

If you can show me what you have so far, that would go a LONG way in trying to answer your question.

Hope that helps,

Joe P.