displaying matching record in report

[Charlie2]

OK I have created a form which shows tenants details, I have also created a report which shows a breakdown of all the tenants rent details.
What I wish to do is create a buttton to link the report to the form so that the report will only show the relevant rent records of the tenant being viewed on the form.
I have tried this and ended up with a button that when clicked only opened the whole report displaying all the rent records.
I also tried linking the button to a macro and then linking the macro to a query displaying only the relevant rent record based on tenantID. The query worked fine but when linked to the macro and button it showed an empty report.
My question is how do I achieve my goal.

Thanks
Charlie

 

[jfgambit]

Do a search for "print current record", this topic has been addressed many, many times in this forum.

 

[Charlie2]

Tried the advice

Great, I found the solution thanks to you.

Charlie