How to duplicate a paper form where course choices are checked off

[teachEmToBeGeeks]

I'm a rookie creating a DB for a nursing home where members are offered a list of courses they'd like to participate in. Each member is given a form with their name and a list of courses, and they check off the courses they'd like to join. I have a table for members, a table for courses, and a table for member_course. I'd like to duplicate the paper form in Access so staff can go through the paper forms, and check off the courses that a member would like to join on the Access form so that member_course_T gets populated, and then be able to view the data by course name with the names of members who chose it. (For example, if less than 5 are interested, the course won't run, or to make sure to notify those 5 about schedule changes). In short, I'd like a form that shows one member and a list of all courses with a checkbox next to each. When the checkbox is clicked, a record with memberID and courseID should be added to member_course_T. Many thanks for your time and assistance!

[ranman256]

then downside of checkboxes. When the user clicks a Save button ,you must use a macro with a series of queries.
each query would append the Course to the tMemberCourse.
q1 : append tCourses.Class from tCourses where [class]='farming' and forms!myForm!chkFarming = true
q2 : append tCourses.Class from tCourses where [class]='math' and forms!myForm!chkMAth = true

and so on. one query for each checkbox. if checked, then it gets added to the student.

[pbaldy]

Would this work for you?

http://www.baldyweb.com/MultiselectAppend.htm

[teachEmToBeGeeks]

Thanks for your help! I did it by creating a temp checkbox field in my course table, showing the list of courses as a subform which allowed them to be checked off, and then when a REGISTER button is clicked, ran a query that added the memberID and the courseID of the chosen courses to the member_course table. Then in a new tab in the form, I show the list of courses chosen from the member_choice table. Now, I need to update the query to reset all checkboxes in course to unchecked.
I'm trying to figure out if, once I've gone to the next member, if I can use the member_course query to repopulate my temp_interested field in course to allow for editing course choices. Any ideas on that?

[pbaldy]

I'm not clear on the follow up question. You understand that your method won't work if more than one person is registering students?

[teachEmToBeGeeks]

I think I figured it out--basically, when the form changes records, it clears out all the checks from tempInterested in COURSE_T. Then it checks MEMBER_COURSE_T to see if there are any records, and if so, uses an update table to recheck the records of the courses already chosen by that member. This enables changes to be made if a member wants to add or remove a course from their desired list of courses. It's a small place so I don't have to be very worried about efficiency, but why won't it work if more than one person is registering students? Do you mean simultaneously?

[pbaldy]

Yes, simultaneously.