I have found a solution to my problem.
Now when you use my filter. The product filter I am looking for gets moved to the top.
Using the following code:
Me![Orders Subform].Form!ProductID.RowSource = "SELECT ProductName,ProductID,Discontinued FROM Products ORDER BY InStr(1, [ProductName],'" &...