ms-access 2007 creating report based on a multi-tables --form

Question

Good Day

tables: authors, books, chapters;

I have created a form(form_A), with a combo-box listing all authors. Created a sub-form that is binded to the combo-box, it list all books by that author, and within that, I created another sub-form displaying all chapters within that book.

The info is from 3 different tables.

when I manually create Report it displays all authors, all books, all chapters. I only want the report to show what was selected on form_A.

ie.. Author Book chapter1 pages chapter2 pages(pages from chapter table)

I'm new to reports... Thank You..