Restrict Report to Current Record

Below, I've inserted a copy of a posting that was helpful to me. I can now print a report for each record in my form even if the subform is blank. However, it has created another issue I need help with. I placed a command button on my form to print the report. Prior to editing the join line as suggested in the answer below, I could click the button from record 6 in my form and generate a report of record 6. Since editing the join line, clicking the button generates a report of record 1 followed by 2, 3, 4, etc. I would like to restrict the report I print to only the record that is open on the form. Is there an easy way to do this? I’m a beginner. Thanks to anyone that can help.

[Question:
I set up a report from two tables - "Staff Table" contains details of all
staff within the company. "Courses Table" contains staff names plus all
courses they have completed.

Each table contains staff's first name and surname in two separate fields.
I have linked these tables using these two fields in order to create a form
and a subform.

I have now created a report with all this information on. However, the
report only shows those staff who have completed courses, and not those who
have not yet completed a course.

I want the report to show ALL staff and the courses they have completed
(if any). Therefore, how do I get the report to also show staff who have no
data in the Course Completed field?

Answer:
In query design, double-click the line joining your Staff Table to your
Course Completed table.

Access opens a dialog that gives you 3 options.

Choose the one that says:
All records from Staff Table, and any matches from ...

Allen Browne - Microsoft MVP. ]

Please disregard... I apologize. I see this has already been answered by Steve Schapel in the posting below this one. Thanks.

"Katherine R" wrote:

Below, I've inserted a copy of a posting that was helpful to me. I can now print a report for each record in my form even if the subform is blank. However, it has created another issue I need help with. I placed a command button on my form to print the report. Prior to editing the join line as suggested in the answer below, I could click the button from record 6 in my form and generate a report of record 6. Since editing the join line, clicking the button generates a report of record 1 followed by 2, 3, 4, etc. I would like to restrict the report I print to only the record that is open on the form. Is there an easy way to do this? I’m a beginner. Thanks to anyone that can help.

[Question:
I set up a report from two tables - "Staff Table" contains details of all
staff within the company. "Courses Table" contains staff names plus all
courses they have completed.

Each table contains staff's first name and surname in two separate fields.
I have linked these tables using these two fields in order to create a form
and a subform.

I have now created a report with all this information on. However, the
report only shows those staff who have completed courses, and not those who
have not yet completed a course.

I want the report to show ALL staff and the courses they have completed
(if any). Therefore, how do I get the report to also show staff who have no
data in the Course Completed field?

Answer:
In query design, double-click the line joining your Staff Table to your
Course Completed table.

Access opens a dialog that gives you 3 options.

Choose the one that says:
All records from Staff Table, and any matches from ...

Allen Browne - Microsoft MVP. ]