Using One Input to Create Multiple Records?

[HMJ]

We have a situation where we have been tasked to input training informaiton about indivdual groups of employees.

(Maybe this should be posted to the Access Forms group - if so, let me know)

What we would to do is use a single form where the user.
(1) selects the group
(2) inputs the training date (Sometime the info is days old)
(3) selects the class attended (drop down menu)
(4) clicks a button to create a training record for everyone in that group.

Can this be done using VBA?

Could I get a little help?


Thanks.

Harry Jessen
HMJessen@Yahoo.com