Selecting Values from a Subform

[David Ball]

Hi,

I want to have a form/subform where I can enter information for new students. On the main form I would be able to enter standard info such as name, address, contact details, etc.
I want to be able to select and assign subjects for each student. I am thinking that all subjects would be available from the subform (there are only 10 subjects) and those applicable to each student are selected from the subform. This would then update the associated table.
How would I set this up?
How do I get a list of all available subjects in the subform?
What is the mechanism for selecting the required subjects (combo box, checkboxes?)?
Thanks very much
Dave

 

[June7]

What you describe is a many-to-many relationship. This requires at least 3 tables: tblStudents, tblSubjects, tblStudentSubject. Subform would be bound to the junction table (tblStudentSubject). Select subjects with combobox that uses tblSubjects as data source for its list.

This is basic Access functionality. Have you studied an introductory tutorial?