Stumped by OpenUrl when trying to open a filtered report with the click of a button.

Stumped by OpenUrl when trying to open a filtered report with the click of a button.

I have two Forms, Accounts (parent) and Jobsheets (child), with their respective reports. They are related in 1:N relationship.

I tried adding a button in the Accounts report, as a column labeled "View Jobsheets". The intent is for the on-click action to open the jobsheets report on the same window, displaying only those jobsheets associated with the record where the on-click action was initiated from.

So far I have been unable to come up with a working code. Either no jobsheet, or every jobsheet, shows when the button is clicked.

Is there a way to do this correctly with a button and OpenUrl scripting? If so, please share a simple example that will get me down the correct path.

Thank you,
RF