mardi 24 février 2015

How do I create multiple (duplicate) records in a single Microsoft Access table from a single form?

I have been creating a main screen for our training organization. From this main screen, I've created a button that launches the form Instructors will use to enter training evaluations. I've had a request to build an additional button that will launch a different form so instructors can put the average scores for each question and say how many attended the class. Once they submit this form, it will need to create as many records as attendees, so that the weight of each day's averages will be fine when running reports.


I can't find a solution to fit my need, but here is the VBA for the button I've tried to use:


DoCmd.RunMacro "DuplicateRecord", Forms!Feedback_Form!Attendees


This doesn't seem to do anything for me. I know it's pretty simple, but I'm new to VBA.


What is the best way to go about this?


Aucun commentaire:

Enregistrer un commentaire