Solved Combobox in Subform not updating data (1 Viewer)

kiaconchim

New member
Local time
Today, 17:01
Joined
Nov 26, 2024
Messages
2
I've attached to files here.

One, in the student form, when selecting a random student, the subform also shows all data related to the student. The course ID column in that subform also allows edits so we can update students' course by a combobox instead of manual typing.
1732591889227.png


I tried to replicate the same thing in the Database2 file but couldn't do it. The combobox might show the course ID but it wouldn't let me choose any value. If I delete the Control source of that combobox, it let me choose the data but doesn't change the course name accordingly.

Please help. Thank you very much
 

Attachments

Change the name of student_ID combo box to cboStudent_ID since it confuses the link master child.
Don't include all the tables in the subform record source. I would only use the tbl_Student_Course.
Set the Course_ID combo box on the subform to two columns with widths of .5, 3 and the Width to 3.5.
Set the control source of the Course Name text box to: =[Course_ID].[Column](1)
Set it to Enabled: No Locked: Yes
 

Attachments

Change the name of student_ID combo box to cboStudent_ID since it confuses the link master child.
Don't include all the tables in the subform record source. I would only use the tbl_Student_Course.
Set the Course_ID combo box on the subform to two columns with widths of .5, 3 and the Width to 3.5.
Set the control source of the Course Name text box to: =[Course_ID].[Column](1)
Set it to Enabled: No Locked: Yes
Thank you very much. It works!!!
 

Users who are viewing this thread

Back
Top Bottom