That should be easy. Should just work. A "read only" somewhere might be the secret.

That was enough to get me thinking right, so thank you. I based the main form on a query that showed CourseID and Title. Coming from a query made it read only. The subform is based on the enrollment table, allowing me to enter who are enrolled in the course.

The only problem is, that the query only provides me with the courses that already have student records associated with them (some quick data that I entered directly into the table). It does show any courses that have no students enrolled yet, so I have no way to "enroll" the students in those classes. I'm still working on that one.

I think I have my problem solved, the two suggestions by MSPhobe got me on the right track:

Quote:

You HAVE based the "make a list of courses" query on the Courses table.... haven't you? (Grin)

Quote:

That should be easy. Should just work. A "read only" somewhere might be the secret.

I decided to not use a query at all, but base the main form on the Courses table, making the CourseTitle the only displayed field, and making it read only. The subform is based on the Enrollment table, displaying only the StudentID field. The mainform and subform are linked via the CourseID fields. This allows me to add students to any course, even those which have no students enrolled yet