Command button that will auto enter fields into table

[dan231]

I'm not sure is this is the right section or not, but here goes...

I am trying to create a db for 6 class programs, each program has from 7-10 individual classes. I have tbls created and a form(frmStudentMaintenance) for new student entry that enters or modifies the student data.

I also have a form(Form1) that shows 1 student info at a time as well as what program they are enrolled in and includes a subform(tblCertPrograms subform) which lists all classes but only radio buttons what classes are in the students program.

What I need now is 2 more items:
1. A command button on the frmStudentMaintenance that will update a new table(tblClassData). This will add a record for each class that is in the program for this student. Layout will resemble:
record1: StudentName, Program, Class1
record2: StudentName, Program, Class2
etc.

2. On the tblCertPrograms subform, I'd like a checkbox that can update a Completed Field in the tblClassData to show if the class has been completed or not. Something to the effect of: If checkbox, then update tblClassData:record:field with 1

My skills are novice to intermediate and any help would be great!
Thanks in advance.

Dan

 

[dan231]

Changed goal slightly

I revamped my form a bit and thus have changed what I need to do slightly.

I was not getting all the data I needed to be linked correctly on a subform, so I scrapped that idea. What I did was to add each class as a field on the tblStudents. I am now able to have all this data from 1 table on the main form1 form.

What I need to accomplish now, is to still have a way to auto populate each class field if it is in the class program. For example: Student 1 is assigned for program 1. Upon update, I need all class fields that are in program1 to be assigned a 1. I'm not sure how to proceed with this part.

Thanks,
Dan