Subreport Display Multiple Options

[tmcrouse]

I have a form with 7 buttons. All buttons have a query that runs when clicked and does display the information in the table based on the query, however I want the results to display in a subreport. I have the 7 buttons to the left of the form and put the subreport to the right of those buttons. I can connect 1 buttons query results and it will display in the subreport, however I want the option to have just 1 subreport and if any of the 7 are selected have it appear in that 1 subreport. I see that I need to put in a source object but it only has the option for 1 source object.

[June7]

You want subreport or subform?

Code can modify the SourceObject property.