Hi. I have a complicated (for me!) database and form. Below is a screenshot of relationships
I have a form (form2-By Subject) based on tbl-Subjects (grid). This has a subform grid based on tbl-Tutorials and there is a further subform based on a qry.
I click on subject and it shows tutorials in grid. Click on tutorial and it shows details.
All works well except for 1 record. Records are correct in tables but when clicking subject it will not show the tutorial. All others are fine. This record is correct in tables.
Difficult to explain so I have uploaded database so you can see what I have done - and hopefully find what I’ve done wrong!!
Download database: https://123club.co.uk/tutorials.zip