Many-to-Many / Forms-Subforms - Updating Junction table

[Enthused]

Hi All - new to this forum. I am sincerely struggling with a many-to-many junction table in respect to getting the values back into it from the 1-many sides of junction table.

Anyway - i think it's quite difficult to explain here - so i've included a Test.zip file. If you open form f_PupilSheets - and get to the "significant" tab of the tab control - you'll see what i mean. It appears as it should or at least how i want it to appear continuous form and with the option to select a Rating of either; yes, no or not known, HOWEVER in it's current state - i everytime i update the Rating field - this update shows for all pupils - not the pupil listed. I can't filter the form by PupilId because then all the indicators don't show.

Help, help - please!

[zmbd]

Enthused:
Welcome to Bytes.

Rating of either; yes, no or not known, HOWEVER in it's current state - i everytime i update the Rating field

More than likely you have the control source and the rowsource set the same in the properties of the control.

This is a quite common error.
Open the properties of the control and look at the data tab:

Here you see the control source set to table and the row source set to a stored query (I often embed these queries here however, for simplicity I used a stored query)

You will need to go into the format tab and set the column widths and so forth. This is an easy search on the MS-Developer's website if you need more detail.

--
on a side note:
Please try to explain your problems without the use of attachements. You see, many of us can not d/l your file for various reasons. Sometimes due to our local IT-Security or company policies, other times as a matter of safe computing.

So:
Start with the version of the OS and Office/Access you are using;
It would be helpfull to know what the database is being used for;
Tell us your goal, what you have tried, and what it is doing.
List the tables your are working with and the relationships
(for example:
tbl_student
[student_pk] - autonumber - primary key

tbl_enrollment
[enrollment_pk] - autonumber - primary key
[enrollment_fk_student] - numeric(long) - 1:m with tbl_student