Copy and paste the child recordset code in code view inside of the repeat region for the parent recordset so that it is re-generated each time it is displayed. It looks like you missed that step. 
Yes, once copy the query inside the repeat region then it works. Thanks.


