subform record to report

[bigmac]

hi all, can you help please, how do i select one record from a subform and open it on a report please? cheers

 

[pr2-eugin]

Use any of the control's double click event to open the Report using the where condition of the DoCmd.OpenReport method..

 

[Mihail]

Manage that the report to be open by using a WHERE clause that have the subform record ID as a filter.