Older Record Disappearing When Filtered

My database contain these:

- Products Table = [ID].AutoNumber, [Product].Text, [Active].Yes/No
- Orders Table = [ID].AutoNumber, [Product].Number, [Date].Date/Time, [Payment].Text
- Orders Form = [ID], [Product], [Date], [Payment]

I have [Product] in Orders Table and Orders Form as Combo Box for showing Product from Products Table.

And within product field on Orders, I want to make 'Active' product only showing up when choosing from combo box.

I made some records to test in Orders Form. Then I filtered Product from Orders Form with query:

Code:
SELECT Products.ID, Products.Product, Products.Active
FROM Products
WHERE (((Products.Active) Like Yes));
Then I changed some product 'Active' to "No"
And the old record disappearing.

How to make older record not disappearing when I filter some of field not being available to choose (because Active product uncheck)

More in-depth, Attachment Database1.zip