List of values with checkbox beside them

[csj1976]

I am trying to set up a staff training database

I am trying to create a form that will display a training session and what I want is a list of all staff members with a checkbox beside their name to be displayed below. I want to be able to assign certain staff members to this training session I have searched the tutorials but have not found much that makes sense - can anyone give me some advice?

[kepston]

I am not so sure that this is easy.
My initial thought is to create a subform based on your staff table with an unbound checkbox. Then code something to create/delete a record in your training session members table when the checkbox is updated.

Alternatively, you could have a subform with no records initially and add members using a combobox. Not as pretty, or efficient from a users point of view, but certainly quicker to create.

The other thing you have to consider is scalability.
How many staff are there? Is this likely to grow rapidly? If it does grow, is there enough room on screen to show all staff? etc
I do not need to know the answers, but you as the designer need to know.