I have limited experience of using subforms and coding, so I wonder if
someone can help me with this one please.

I have a database with 2 tables; one for courses, one for students. What I
want to be able to do is have a form for my courses and include a subform to
show the number of students on that course. I would like to limit the number
of places available on each course and to have only that number of fields
showing on the subform. In other words; if there are any spaces, I will have
empty fields on that form. I have to be able to delete a student's details if
they drop out of the course.

As always, I would be grateful for any advice offered.

Thanks,

Tazzy