Controlling forms from more than one table

[jaarons]

I have another question. For the purposes of this question, I have three tables:
Students
Guardians
Students and Guardians

Students has ID, First Name, Last Name
Guardians has ID, First Name, Last Name


Students and Guardians has Student (Primary Key, linked to Students -> ID), Guardian ID (Primary Key, linked to Guardians -> ID), Relationship (Combo box with values like mother, father, etc), Lives With Child (Yes/No box) and Emergency Contact (Yes/No box)

Now I also have four forms
StudentsAdd
StudentsView
GuardiansAdd
GuardiansView

Students forms are identical with the same fields as the tables, but StudentsView is set to Modal->No and has Next record, previous record buttons. StudentsAdd is set to Modal->Yes and has save record, cancel record buttons.

Guardians forms are the same.

Ok, so here's the question. I want to link the information in the Students and Guardians table to the GuardiansView form.

Specifically,

In StudentsView, I want a text box showing all guardians listed in the Students and Guardians table as having a relationship with that student. I want to see the relationship text box as well as the two yes/no fields.

In GuardianView, I want a text box showing the student listed in the Students and Guardians table as having a relationship with that guardian. Again, I want to see the relationship text box as well as the two yes/no fields.

Thanks for any help you might have!

[June7]

Your post title doesn't make sense. Forms are not controlled from tables. Forms are bound to tables/queries.

Yes, more than one form can use the same table/query as RecordSource.

A textbox would show only one value, not 'all guardians'. To show 'all' would require a combobox, listbox, or subform.

It is possible to use same form for both adding and viewing records (1 for Students and 1 for Guardians).

A form/subform for data entry is probably what you need. Two options.

1. Main form bound to Students and subform bound to StudentsGuardians

2. Main form bound to Guardians and subform bound to StudentsGuardians

[jaarons]

Sorry, I'm still new to Access, so bear with me. I have the following form for Students (see pic)

EDIT: picture removed by moderator.

I actually like that I have seperate forms for data entry and for viewing. That's all set up. What I want is a field on this form that says Guardians and that any guardians linked to this student (by studentID/GuardianID) show up in a text box/list box/whatever.

How do I do that?

Tables are:
Students
Guardians
Students and Guardians

Forms are
StudentsAdd
StudentsView
GuardiansAdd
GuardiansView

How do I, as you say, use more than one table/query in a single form. I know I can click Add Existing Fields, Show All Tables and choose the Students and Guardians table, but how do I make sure that for each record, only the guardian/s assigned to the student come up in the field?

Thanks!

[June7]

To show the guardians for a student would require a combobox, listbox, or subform.

A combobox or listbox would have a RowSource with filter criteria that is dependent on the Student ID of the current record and would require code to refresh the box when navigating records.

A subform records would synchronize with the student record by setting the Master/Child links of the subform container control.

I removed the image you attached to post because it looked like real data.

[jaarons]

Thanks. No it was fake data since I was posting it, but thanks for being careful. Hmmm. I'll have to experiment. Thanks anyway.