Subform Not Updating Table 1

[fsupport1600]

I thought I had this database working exactly how I wanted it to till recently.

I have a form with a subform on it for selecting products. If a product is selected in the subform, saved, and then later deleted it does not delete it from the table, so when I run my report the entry still exist even though my subform does not show it.

I have attached my database in efforts to better explain the issue.

Steps to reproduce the problem:

1. Go to the "Product Selection by Room" form
2. Go to Room C107

Their are 3 products in the list that have been selected for this room. H103, H130, and H131.

3. Run the report, "Product Count and Room Location"

Product N101 appears and list room C107 with a quantity of 2.

From what I can tell FunitureSelectionID table is not getting updated with the deletion of the N101 product from the C107 room from the subform on the Product Selection by Room form.

Is their something incorrect with my "Product Count and Room Location" report?

 

[MajP]

SELECT tblFurnitureSelection.FunitureSelectionID, tblFurnitureSelection.prodTagID, tblProducts.prodTagID
FROM tblProducts RIGHT JOIN tblFurnitureSelection ON tblProducts.prodTagID = tblFurnitureSelection.prodTagID
WHERE (((tblProducts.prodTagID) Is Null));

See your problem? Orphans