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 completely blank; no focus is given to any of the records. The same thing happens if I have a record in the first subform which does not have a corresponding record in the second subform. I have setup the info for the sofm/subforms as queries. Any ideas? It seems like it needs code to adjust it.

Many Thanks in advance.

Check the master/child links to the subforms.

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.

Hello sahmad,

It sounds to me like you have referential integrity enforced on your relationships and one of the participants does not have a related record in it.

Just a thought
Robin.

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.