Subform Not Updating

[c00kieM0nster]

Hello everyone new here;

I am setting up an access database for my work, which will record behavior points scored by each individual kid. I have set up a Form and a Subform however my Subform is not updating to the relevant ID.

I have a Form which the user selects the the class they are teaching, followed by the child they wish to award the points too. Please note these are both cascading Combo boxes, and the ChildName combo box has the ID hidden in it.

In the back end the tables are linked by the child ID, this is the primary key in the Studentlist table and a foreign key in the Points table.

I Have set the Subform to link to the Studentlist table via ID but alas if i Change the child it still won't update the form to show the relevant ID.

Any help would be much appreciated I haven't touched access in Years.

 

[Trevor G]

Welcome to the forum,

Have you checked the Child & Master Fields for the subform?

 

[c00kieM0nster]

Yeah the parent one been ID and the child one ID. I have tried renaming it to the combo box name to no avail.

Thanks for the suggestion.

 

[Trevor G]

Can you upload a sample of the database.

Also I created a behaviours database a while ago for a school perhaps this may help you. Attached copy, use my name to get in and also the password is password as it is a test sample. You can add logos etc.

 

[Trevor G]

Yeah the parent one been ID and the child one ID. I have tried renaming it to the combo box name to no avail.

Thanks for the suggestion.

Your new message hasn't appeared in your thread, perhaps a suggestion would be to upload a sample either in your thread or via a 3rd party like drop box and I can take a look as long as I know the form Names etc.

 

[c00kieM0nster]

Yeah sure had to remove all data and branding for safe guarding. Stuck you in some test data though.

And thanks for the example. Given me a lot of ideas of how I can grow this database. But just need a simple one for September

Once again thanks for your assistance.

 

[Trevor G]

I have had a look and your relationships hasn't been set correctly, so I have altered the database you have add to your thread, look at the relationships and you will see 1 to Many has been set. I also removed the Incident Log table, pointless if you are adding for each day just add the field to the day register.

Attached returned copy. Perhaps this will help you. At some point look up Normalization your database that will help.

 

[c00kieM0nster]

Thanks given me a solid platform to work on. I'll have a read on the normalization.

Your Help again is much appreciated.

 

[Trevor G]

Happy to help and thanks for posting back.