Adding multiple records to one table with one form

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,

I have a database that tracks students and the programs that they
participate in. I have a form(participation) that needs to allow the
users to select the program(from a combo preferrably(yes i have a table
for programs)), time, and date(these must be txt boxes). I would like
to use combo or list box(es) to select the students that participated
and the program and then have a button on the form to add as many
records to the participation table as there are selected students. I
am stuck on the code for adding a record for each student that
participates. Any help on this would be greatly appreciated. Thanks
in advance.

Tables Fields
(Students)
{studentID}
(Participation)
{participationID}
{programID}
{studentID}
{time}
{date}
{participationpoints}
(Programs)
{programID}
Form
(Participation)

P.S.
I am a newbie with VB. I would have posted the VB code I have...but, it
is so screwed up from the things I have tried that I think you would
just laugh...anyhow, thanks again.

.

Quantcast