<div>
<div class="content wysiwyg-content">
I have a Main Report with a subreport that should display the totals for the current record only (contractID) &nbsp;<br />
<br />
I am using the Master/child link, however, the subreports seems to display all values.<br />
<br />
I even tried limiting the query of the subreport using a variable - without success.<br />
<br />
What is the best approach to display only those values on the subreport that matches the current record on the Mainreport?
</div>
</div>


I have a Main Report with a subreport that should display the totals for the current record only (contractID)  

I am using the Master/child link, however, the subreports seems to display all values.

I even tried limiting the query of the subreport using a variable - without success.

What is the best approach to display only those values on the subreport that matches the current record on the Mainreport?

Subreport - Limit to current report ContractID

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.