I have tried to do the above but it just prints out all the active records - does anyone know how to make it print the current report only????

First build your report, either ussing a query to select the desired record or, if not too many field, reference the form for fields placed on your report.

Use the button wizard on the Tools toolbar to build a button to open the report.

You have to have a report before you can build a button to open it.