Link table in n<->n relationship: Subform is empty (no controls) so I can't add data.

[rcv]

Using Access 2010, I have two tables (Students and Classes) in a many-to-many relationship linked through a "tlnk_student-class" table. I have created a main form that is used to look up the student, which is linked to a subform that shows the classes to which the student is registered. I want to be able to add students and classes in which the student is enrolled on the form (and subform). I have a query (qlkp_student_sort) that sorts tbl_student and populates the main form. This main form allows me to view and add students to the main form. (So far, so good.) I have also created a query qlnk_student-classes that uses tlnk_student_class and tbl_classes to get the class data and sort it by student_id. If a student has classes in tbl_class, the class appears on the form, but I can't add new classes AND if the student does not yet have any classes in tbl_class, the form is blank - no controls appear so I can't add classes by using the form. What have I missed? Any help would be appreciated. rcv.

[rcv]

Also, the "Allow Additions" Property is set to "Yes" on both the Main Form and the Sub-form.

[orange]

What is the difference between Registered and Enrolled? Where does "tlnk_student-class" fit?

I responded to a post concerning m:m relationship recently - it may be helpful to you.
see https://www.accessforums.net/forms/c...tml#post132322

[rcv]

Registered = enrolled. Sorry that I wrote that badly. One student can be enrolled in many classes, and one class can have many students, so tlnk_student-class has (as foreign keys) the primary keys of both tables as a record.

[June7]

Are the RecordSources direct to tables or are they queries? If queries, could be issue with jointype if multiple tables in the query.

Want to provide db for analysis? Follow instructions at bottom of my post.