I need a subform that can pull info from a main form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a main form that pulls up scheduled sessions for tutors with specific
subjects and instructors. I need a subform that will list the students in
that session and allow me to add students to the session. I have tried to
create a subform with its own query but that didn't work and I am out of
ideas. Can anyone help?

Thanks
 
I have a main form that pulls up scheduled sessions for tutors with specific
subjects and instructors. I need a subform that will list the students in
that session and allow me to add students to the session. I have tried to
create a subform with its own query but that didn't work and I am out of
ideas. Can anyone help?
Click to expand...

The first thing to bear in mind is that data is NOT STORED IN FORMS.
Forms are just tools to allow you to interact with data stored *in
tables*. How are your tables structured? How are they related? I'd
expect at least four tables - Tutors, Students, Sessions, and
Enrollment (a many to many bridge table linking Students and
Sessions), and that you could use a Form based on Sessions with a
subform based on Enrollment, using the SessionID as the master/child
link field.
 
Back
Top