Limit on number of records

[Tazzy via AccessMonster.com]

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

 

[Jeff Boyce]

I think you have something missing...

If you have Students and you have Courses, don't you also have "Enrollments"
(Student x Course combinations)?

While a Course might have a limited number of places, you could count the
number of Enrollments using that Course to see if you've reached capacity.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/