Originally Posted by
aytee111
I just noticed a mistake, my exam for has a query as its record source (not sure where that came from), it should be the exam table by itself. Queries aren't necessary in this scenario.
Create all of this for yourself, follow the steps I outlined in post #22. Use the form wizard to create the forms based on the tables, then add the forms as subforms as described. There is one form per table, you provided 4 tables so there are 4 forms. Not that many! Under the Design menu click on the subform icon, a wizard will appear, use that to add the subforms. All very simple and a good learning exersize.