Set the id of sub-forms in a report

[dmcb]

I have 1 report that contains 2 sub-forms. The Report is unbound and each sub-form has its own control source. Sub-form's 1 control source is Table 1 and Sub-form's 2 control source is Table 2.
Is it possible to open the report and set the ID (record ID) of both sub-forms. So for example could i use a button to open the report and set the ID of the sub-forms to 3 ?

[June7]

You want to filter each subform recordset to the same ID?

One way would be to have the subforms use parameterized query as RecordSource. The parameter would be a reference to control on a form that displays the desired ID value.

Review
http://datapigtechnologies.com/flash...mtoreport.html