Print Report From Form Page

[Theman]

Can anyone tell me how to print a report of the current record of my form from a print button? I have a report template that is populated by the data but say when I am on record 6 of the form and hit the print report button I get all six pages instead of just a report of record 6. Any info is appreciated. Thanks.

 

[antomack]

Put code behind the button to use the OpenReport method to open the report with a where condition to open to just the record you want. See the help file under OpenReport Method.

 

[Theman]

I got it working; thanks.