Hi @arnelgphere test your db using your
FilterComboAsYouType() function.
Could I use that code on an unbound combo box with horribly messy row source: SELECT DISTINCT TypesAll.TypesAllID, [Type] & " " & [SubType] AS FullType FROM (TSub INNER JOIN (T1 INNER JOIN TypesAll ON T1.TypeID = TypesAll.TypeID) ON TSub.ID = TypesAll.SubID) INNER JOIN Product ON TypesAll.TypesAllID=Product.[FullType]; ?