sub form report

[bigmac]

can yo help me please i want to open a report but only showing the result of one record in a sub form,

i have a field that is on all rows of the subform,[click to run] and what i want the user to be able to do is double click on this field and it will open the report with only the record information for that row displayed.
is this possible please,

 

[pbaldy]

I would use this with OpenReport:

http://www.baldyweb.com/wherecondition.htm