Should I use a query in a form to do this

[forest8]

Hello all

As stated in the subject, can I use a query in a form to do this?

I want the all the information in the Students table to appear in a form as
a query.

The Student table contains information on each student, e.g. first name,
last name, student number, home room teacher, etc.

In the Subjects table, I have recorded the classes the students are have
enrolled in, the names of the subject teachers, their marks, year of
enrolment, and comments for each student.

I want the information from each student to appear in a form where teachers
enter the relevant information and know which student they are referring to.

Essentially this is a report firnm to enter the data and not a report.

Thank you in advance.

 

[bhicks11 via AccessMonster.com]

You can use a query as the data source of a form. If I understand you, you
would create a query with the students table and the subjects table related
on the students name (or whatever unique identifier you have used - student
name isn't good because you could obviously have multiple students with the
same name). You would filter the form based on the teacher name either from
a parameter in the query or on the form.

Bonnie
http://www.dataplus-svc.com