You have to add a parameter to the subcategory recordset to filter it from the value from the first so that it only shows the children. Then you have to manually copy and paste the recordset code so that the second recordset is defined inside the repeated region for the first one.