I am building a database for Students and Courses where the relationship is many to many and use a Link entity table with a composite primary key between the two.(ie the FK of Students and Courses). I want to create a Form for Courses to be entered then be able to select Students earmarked for the course and display the list in datasheet view as a subform. I also need to produce a Form to view individual students but also include a subform showing the list of courses a student has been selected for. The difficult bit is selecting the students and making use of the results.

I am not a VB blackbelt so any help will be greatly appreciated. I am designing it in 2002 but will need 97 functionality.

Thanks in advance