I am creating a learning tool using Access for my students. Currently I have a topic form, this has a number 1 to many relationships going from it to other tables, such as 'questions', 'exercises', 'theory' etc.
I know how to create a command buttong to access these other forms, however it accesses all the information in these forms. To explain better, if I have the Topic 'addition' and a command button linking to the Question form, i only want it to show the 'addition' questions, not all the other questions in the database. Any advice would be much appreciated,