Search form combo box filter

[whojstall11]

I have an Search form with two combo boxes it works almost correctly. On update when i use the drop down menu it gives me my criteria.

What is does:
When I use the other combo box after my uses my first one it just adds to the results that are already there.

I need for it to do:
As i use my combo boxes it filters out all my data based on the criteria I have selected.
Can you help

SELECT [Hardware Asset].DeviceType, [Hardware Asset].AssetNumber, [Hardware Asset].[Date Recieved] AS [Date Recieved2], [Hardware Asset].Depreciation, Date()-[Hardware Asset].[Date Recieved] AS Expr1, Order.[BU Purchased For], D2YMD([Expr1]) AS Expr2, [Depreciation]-[Hardware Asset].[Date Recieved] AS Days, D2YMD([Days]) AS [Time Left], [days]-[expr1] AS Expr3, D2YMD([Expr3]) AS [Time Left2]
FROM [Order] INNER JOIN [Hardware Asset] ON Order.[PO Number] = [Hardware Asset].[PO Number]
WHERE ((([Hardware Asset].DeviceType)=[forms]![deReport]![Text217]) AND (([Hardware Asset].[Date Recieved]) Is Not Null)) OR (((Order.[BU Purchased For])=[forms]![deReport]![Text417]))
ORDER BY [Hardware Asset].DeviceType;

[June7]

What is that sql for? Is it the RecordSource of form?

I don't really understand your question.

Do you want to provide db for analysis? Follow instructions at bottom of my post. Identify the objects involved in this issue.