By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,561 Members | 3,127 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,561 IT Pros & Developers. It's quick & easy.

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

P: 1
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 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!
Attached Files
File Type: zip Test (2).zip (51.2 KB, 74 views)
Dec 1 '13 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 5K+
P: 5,397
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.

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:
[student_pk] - autonumber - primary key

[enrollment_pk] - autonumber - primary key
[enrollment_fk_student] - numeric(long) - 1:m with tbl_student
Attached Images
File Type: jpg cbobx.JPG (24.0 KB, 810 views)
Dec 2 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.