if you are happy for your subreports to be in datasheet view then you can do the following.
1. create a form in datasheetview based on a table our query - i.e. click on a table or query then click on Create>More Forms>Datasheet. Save the resultant form as say 'FlexForm'
2. In report design, drag this form onto the report. - Assume the sub control is called subFlexForm.
3. You then need some simple code (suggest create a button on the report for now and use the click event for testing) as follows:
Code:
me.subFlexForm.SourceObject="Query.AnotherQuery"
Where AnotherQuery is the name of another query
if you want o have a table, the use "Table.AnotherTable"
You can still use the linkChild and LinkMaster properties - for filtering purposes - just may need to change names if required
Note you need to use a form as the sub report since reports do not themselves have a datasheet view