The problem...
I have a category ID that I'm using to identify what type of product that the item is. I was still including this as an INNER JOIN in the products recordset on my detail page, but it wasn't needed because I was filtering from the greeting cards page by the product ID. So, you were right, the unused INNER JOIN was causing the issue. Thanks for your input.
James