Button on form to display report only works for one record.

[faythe1215]

I have a "print" button on my "frmRecipes" form. When the button is clicked, it's suppose to open "rptRecipes" filtered on the ID number.


It only works for the first record, though. It won't work on any others.

I have attached the database for troubleshooting.

RecipeReport.zip

[June7]

Change the criteria to:

"ID = " & Me.ID

The report works for ID 1 and 9 but ID 2 does not have records in the report query. This is because the query joins tables with INNER JOINs.

[faythe1215]

I have information missing and so when the fields are empty, some of the records don't show.

That's what it is... THANKS!