Adding Training Records to a Database

[Peter5164]

I have three tables Volunteers, Training and trnEvents. I am wanting to create records under training for each volunteer with the name of the event and the completion date for each. What I envisage is opening a continuous form and seeing all the volunteers there (some will have completed the training already) and the I can click a button to create a new record in Training and add the training event and the date for each person. I have attached the form I am using. Am I on the wrong track? Is there an easier solution?

[CJ_London]

Would help to see your table structure and relationships as the image doesn’t tell us anything useful

[Micron]

Strictly from a form design perspective: IMHO a listbox with volunteer names would be the way to go. Its list would be generated after you choose from the required combo(s). You could then multi select from that list and apply all the settings as a record for each selected volunteer.

[madpiet]

I like the listbox method too.... you can use paired listboxes where you move the Employee names from one listbox to the other (using buttons) and then you can just click a button to run through the items in one listbox... or the Selected Items collection...