Master Form/ Sub Form

[cindyLiu]

Looks like Yes. I will take a look and like you know later.


Thank you very much!

[cindyLiu]

I just checked and the combox doesn't link with the student selected courses. on the subform, for each student, the combox should only show the courses related with this student. if the student has one course, then only show this course; if student has 3 courses, then show these these courses. please see the table for "student selected courses" which i post yesterday. Thanks!

[cindyLiu]

I only have a problem with the combox. here is my real sumform

[davegri]

I only have a problem with the combox. here is my real sumform

You keep mentioning a combobox not working. What combobox are you referring to?

[cindyLiu]

right of Recovery Service 1, and right of Recovery Service 2. These two files should use table "student selected courses".

[davegri]

I don't understand the problem.
subForm is only showing one record related to the master form record.

Perhaps you should explain more of how the tables are related. What are the logical relationships between TBL_CourseDetails, TBL_RecoveryServiceDetails and TBL_CourseList? What is the database supposed to accomplish?
Is TBL_CourseDetails used in your posted DB at all?

[cindyLiu]

1. FRM_Registration (Master Form) –Data source: TBL_Student_Parent
2. FRM_RecoveryServiceDetails (Subform):-- Data source: TBL_RecoveryServiceDetails

Link Master Fields: student_id
Link Child Fields: studentid

3.Combo box (Right of Recovery Service 1)--- data source: TBL_StudentCourse
4.Combo box (Right of Recovery Service 2)--- data source: TBL_StudentCourse

5.For these two combo box (drop down), they should be only shown the courses related with the correct student (detail see TBL_StudentCourse)
6.All the information in subform should be saved into TBL_RecoveryServiceDetails

please see updated database

[davegri]

Both comboboxes need this rowsource:

SELECT distinct [TBL_StudentCourse].[Course Name] FROM [TBL_StudentCourse] Where Student_ID = Forms!frm_Registration.Student_ID ;

HOWEVER, the design of the subform's table is wrong. Instead of repeating courses horizontally in a student's record, a NEW record should be added for each course, as demonstrated in post #15.

[cindyLiu]

Thank you very much, i will go back to take a look #15