Recent content by sahmad

Hi Robin, Thanks for the suggestion, however I have no referential integrity enforced as yet. I am trying to figure out which event I should write code for so as to get the form to be updateable, as it seems to me that is where the problem lies. Any ideas? Thanks again in advance.

Thanks Pat but I have checked the links they seem to work fine in that the data is synchronised properly in the forms/subforms. If I am missing the point I hope you will clarify further. Thanks.

I am having trouble entering a new record in a subform which is part of a form-subform-subform setup. The form and subforms are based on tables which are all linked by many to many relationships. When I click to enter a new record on the subform or the main form the second subform goes...

I am having trouble trying to enter data into a subform which is synchronised with another subform. If I click to enter new data on the main form the 2nd subform goes completely blank whilst the 1st subform allows me to enter info. I have checked the settings for data entry for the 2nd subform...

I am trying to create a form with two synchronised subforms but am having problems. My form is based on a table (A) and my two subforms are based on two further tables (B and C). Table A has a many-many relationship with table B which further has a many-many relationship with table C. I can...

Thank you Pat for the suggestion, however two things: First although I insert the Assignments subform into the Classes subform I cannot see the related data. Should I create the Assignments subform as a query or stand alone form before inserting it and what should the Child and Master links be...

I would like to create a main form with two linked subforms as follows: Students (Main) Classes (subform1) Assignments (subform2) Where Classes is linked to Students and Assignments is linked to Classes. The tables for the above are as follows (where ----> indicates a one to many link)...