How Do You Open Multiple Data Entry Lines ?

[HMJ]

I hope someone out there can help us. The situation is that we have two tables with the fields indicated.
Table1:
Emply_ID
Employee_Name
Employee_section

Table2:
Emply_ID
Training_Class
Training_Date
Comments


On form #1, we would like to:
...(1)Select the section that training was given to(this we can do via dropdown list)
...(2)Enter the date the training was done
...(3)Select the name of the class taken(this we can do via dropdown list)
...(4)Click the continue button and open a form(s) for each member of the section, with the dates and class already entered.

This would enable us to indicate in the comments why someone did not make the class, or any other comments needed, as well as make one entry for the entire section.

How can this be done?

Thanks.


Harry Jessen
HMJessen@Yahoo.com

 

[Rolliee]

Place four unbound textboxes on the Main Form. Fill them as you describe above. Then at a cmd button, open the table two, add the information from the four b oxes and any other informtion and tell the usere is it done, Clean up and get out.

rollie.gantlet57819@zoemail.net

 

[HMJ]

To: Rolliee

Okay, I can see that, but how do you create one record for each of the 'x' number of employees assigned to the section. Each employee should have his/her individual record in table2 when this is done.

That is what is causing the headache.

Thanks

Harry Jessen
HMJessen@Yahoo.com

 

[Rolliee]

Using vb loop through all the employee's records. If the employee meets the criteria, create a new rec with his/ her ID on it.

Rollie